Merging multiple files into one master
Hello everyone,
I am trying to merge multiple excel documents into one master document without copying and pasting or importing them one at a time. Each day a file is created with the previous days data and right now I have about 2 months worth of these files. All of the column headers are the same so I'm hoping there is a way to take the contents of all 60 or so documents and put them all into one without a lot of hassle. Any help would be greatly appreciated. Thanks.
'WORKBOOKS TO 1 SHEET
I have a macro that may be pretty close to "ready to use" for collecting data from all files in a specific folder.The parts of the code that need to be edited are colored to draw your attention.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Shoot, I was hoping there was a way without having to use a macro. I'll see if I can get that to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks