Link to home
Create AccountLog in
Avatar of dnewman33
dnewman33

asked on

merge multiple excel files sheets into single file: excel 07

I have 42 files with 1 sheet each and I'd like to merge them into 1 file. Is there an easy way?
ASKER CERTIFIED SOLUTION
Avatar of John
John
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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
Thank you, and I was pleased to help you.
.... Thinkpads_User