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
A start would be Data=consolidation with the macro recorder on. That
would show you what type of array of files it needs. Then you can build that array using FileSeach object. -- Regards, Tom Ogilvy "Mike Fogleman" wrote in message news:7WRed.240972$wV.110340@attbi_s54... 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 Several Workbooks into One | Excel Worksheet Functions | |||
consolidate 2 different workbooks | Excel Discussion (Misc queries) | |||
Consolidate data from several workbooks | Excel Worksheet Functions | |||
Consolidate data from several workbooks | Excel Worksheet Functions |