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

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