Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate Data from other workbooks
I get weekly reports from 13 different sites that I save together in one
folder. All reports are done on the same template so data is in the same ranges for each report. Each report will have a different file name. Not all sites may send a report. I want to create a Master Report to be included in the same folder that has the data sums from the other reports. I would think it best that this Master be the same blank template that the reports use and consolidate to the same ranges. I will also want to add to the Master, the file names of the site reports so there is a list of which sites submitted a report for this Master. Any pointers on how to start a macro for the Master Report would be appreciated. TIA.. Mike F |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate Data from other workbooks
Maybe you can use this Mike
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mike Fogleman" wrote in message ... I get weekly reports from 13 different sites that I save together in one folder. All reports are done on the same template so data is in the same ranges for each report. Each report will have a different file name. Not all sites may send a report. I want to create a Master Report to be included in the same folder that has the data sums from the other reports. I would think it best that this Master be the same blank template that the reports use and consolidate to the same ranges. I will also want to add to the Master, the file names of the site reports so there is a list of which sites submitted a report for this Master. Any pointers on how to start a macro for the Master Report would be appreciated. TIA.. Mike F |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have workbooks to consolidate data from on one report | Excel Discussion (Misc queries) | |||
consolidate 2 different workbooks | Excel Discussion (Misc queries) | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Consolidate Data from other workbooks | Excel Programming |