Consolidate Data from other workbooks

M

Mike Fogleman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidate historical stock returns from multiple workbooks into oneworkbook 1
Merge Multiple workbook sheets into one workbook 0
Macro for uploading data from other Excel files 5
Gathering data from all xl files in a folder 5
Automation of Excel Report using Access Data 5
saving And rename source file 1
Consolidate many WBs into one ... 2
Save record Into master sheet! 1

Top