asked on
Excel Combine Multiple worksheets into one
I am having trouble combining 200+ worksheets into one sheet. I have attached a sample file to show the data, and what it should look like. There is a sheet called Template to show what every sheet looks like, they are all in the same format, but not every information is filled. I added two sample data sheets called, '3M ESPE Retraction Capsule' and 'Acupeds'. The sheet called 'Final' shows what it should look like after those two sheets are combined into 'Final'. I need some help for combining multiple sheets (200+ sheets). Is there a macro to do this so I don't have to do it manually?
Book1.xlsm
Book1.xlsm
Microsoft ExcelMicrosoft OfficeVBA
Last Comment
Shums Faruk
ASKER
I dont think this will work, as the my original templates' headers are not in columns, and I want to put this in columns as well.
ASKER
Still looking for some help on this
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
Thanks for that, it worked! I was busy with something else so I didn't have time to test it immediately
You're Welcome Bob! Glad I was able to help.
If this does not help you then you can come back and we will try to help you