![]() |
|
#9
|
|||
|
|||
|
I have been having trouble entering the range. When I browse and add the file I want, the file path is longer than the typing area. If I click on the file path and try to arrow along to the exclamation mark, the range appears midway. However, I finally managed to get the four files up with the range in the correct place and the final total is correct but I am getting peculiar dates, eg 28/12/32 instead of 28/04/16. Any ideas?
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Move & Consolidate Data | meggenm | Excel Programming | 1 | 08-27-2017 12:54 PM |
| Add data from two Excel Files to Word Doc Template | nivolaped | Word | 4 | 04-10-2016 04:23 PM |
Merge the data from different excel files.
|
Sandhya | Excel Programming | 2 | 10-10-2015 02:53 PM |
Consolidate data from different excel sheets
|
Sandhya | Excel Programming | 1 | 10-10-2015 12:28 AM |
| How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |