merge multiple excel files sheets into single file: excel 07

dnewman33
dnewman33 used Ask the Experts™
on
I have 42 files with 1 sheet each and I'd like to merge them into 1 file. Is there an easy way?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Someone may have an elegant VBA or Macro way (I shall watch), but it seems a one time thing, I would probably just move them in. You will be done in about 10 minutes and can watch for potential anomolies that arise at the same time.

... Thinkpads_User

Commented:
You can take a look at my article and adjust the code there to suite your needs:

http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html

jppinto
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Thank you, and I was pleased to help you.
.... Thinkpads_User

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial