Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collate information from different files via a macro
Hello
I have 10 files (1 per person- S:\data\(initials)) they have the same format (1st four columns) with data in them with the first row as a header. I wish to create 1 file for all this data, is there an easy way to obtain the data from all the files and create a new one under S:\data\combined without having to open then all 1 by one and copy and insert the cells into the new combined file (the data range also changes on a day to day basis). Please can you provide suggestions, thank you in advance for your help. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collate rows from several files into one new master file | Excel Discussion (Misc queries) | |||
excel print macro, do not collate | Excel Discussion (Misc queries) | |||
Looking up information in closed files | Excel Discussion (Misc queries) | |||
i want to edit the same information in ten different files | Excel Worksheet Functions | |||
Excel macro to extract information from MS project files | Excel Programming |