I am looking to merge multiple workbooks that contain the same three tabs.
Tabs:
Animal
Food
Place
I am looking to merge multiple workbooks that contain the same three tabs.
Tabs:
Animal
Food
Place
Last edited by Heather.Taylor; 08-04-2011 at 01:34 PM.
Hi,
Have a look here?
http://www.excelforum.com/excel-prog...g-headers.html
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
'WORKBOOKS W/MULTIPLE SHEETS MERGED INTO SHEETS IN CONSOLIDATION WORKBOOK
Here's a macro for collecting data from all sheets in all files in a specific folder merging into matching sheets.The parts of the code that need to be edited are colored to draw your attention.
I'm pretty sure all you need to edit is the the fPath string to properly point to where your source files are located. Then edit the fName code to .xlsx.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon 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 that macro, but for some reason it doesn't go to that file path but it opens other random spreadsheets to copy over.
Hi Heather,
Are you using this code? Can you post your changes to this code
Please Login or Register to view this content.
Yes I am.
Please Login or Register to view this content.
Last edited by Heather.Taylor; 08-03-2011 at 11:00 AM.
I'm no networking guru, but you changed to drive U: which sounds like a network drive to me. Perhaps that could be giving you issues. Do you know the network address of the same drive? Not the locally mapped version? That might work better.
Look at my signature, it shows the proper way to wrap your code in tags. Please edit your post above to use the proper tags. You could also edit out all the code you didn't change since it's already posted in this thread...keep things tidy.
I changed the fpath to my desktop and it stops at this part of the macro.
Set wsMain = wbMain.Sheets(wsData.Name)
When it stops and you DEBUG, hang your mouse over the wsData.Name variable and tell me what the current value is that appears.
wsData.Name = "Advance - Datacomm" (which is the first sheets name on my spreadsheets)
So, the problem is occurring when the macro tries to set the wsMain sheet variable to the sheet Sheets("Advance - Datacomm") in the workbook that is your wbMain, there is something not matching exactly. This is usually hidden spaces or something like that...
"nevermind"
Last edited by Heather.Taylor; 08-04-2011 at 01:32 PM.
"nevermind"
Last edited by Heather.Taylor; 08-04-2011 at 01:33 PM.
Just edit the post above and delete the content, replace it with a "nevermind" comment.
Then go to post #1... click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks