Hi,
I have multiple Excel files with the same structure (same sheets and column headers). Each file has multiple worksheets. My master file has same structure, too, but it has no information in it.
I need to gather data from all files and combine it in the master file, duplicates are ok. I know that Access is right for that job, but I am not supposed to use it...Can someone please help me with the VB code to merge all data in one master file?
Thank you!!
This code will open all the files in a single folder and import the activesheet into your master file's activesheet. It is not currently designed to import multiple sheets into multiple sheets. Hopefully this will get you most of the way there.
Please Login or Register to view this content.
_________________
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!)
I tried this macro tonite and it didnt do anything. I clicked run but no data populated. Am I doing something wrong?
Let's see your version of the macro. Post it here, don't forget to put code tags around it like in my post above.
Please Login or Register to view this content.
Try this updated version:
Please Login or Register to view this content.
How do I add more than 1 range?
Explain further.
Originally Posted by JBeaucaire
I tried the script and it still doesnt work. Im going to close this thread because I am working on other leads. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks