How to put multiple files into one
I have an excel file for each day of the month. Each file has 2 sheets for sure and some files have 3. I want to make one master file at the end of the month that shows all sheets.
*1st sheet is master report. 2nd & 3rd sheets are created as a pivot table
Any help would be greatly appreciated.
Last edited by Gonefishin; 09-24-2009 at 11:04 AM. Reason: I forgot to mention
Do the daily excel files have a consistent naming convention or are they all in one folder, and are they the only excel files in that folder?
The general process in VBA would be:
1. Create Master Month excel file.
2. One by one, open each workbook, copy each worksheet in it into the Master Month workbook, and close the workbook.
3. Save the Master Month excel file.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Why don't you use one sheet to record all the daily data, then you can use AutoFilter or better still pivotTables to summarise the data?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks