Rowby Goren
asked on
Combine many excel files into one workbook
Hello
I may have asked this before but I can't easily find it in "My Answered Questions". And in this version I am asking for a slightly different "solution".
I have a bunch of excel files in one folder. Each one has 1 workpage. They all have the same column headers.
I want to combine those files into one workbook. They can each be a different page of the workbook or, even better, they can be combined into one workpage -- since they all have the exact same structure and headers.
Any solutions to do that?
Thanks
Rowby
I may have asked this before but I can't easily find it in "My Answered Questions". And in this version I am asking for a slightly different "solution".
I have a bunch of excel files in one folder. Each one has 1 workpage. They all have the same column headers.
I want to combine those files into one workbook. They can each be a different page of the workbook or, even better, they can be combined into one workpage -- since they all have the exact same structure and headers.
Any solutions to do that?
Thanks
Rowby
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
HI Terry
I looked at that solution and yes I am using it when I have one workbook with multiple Worksheets in it. I run the Visual Basic to combine the multiple worksheets into one "consolidated " page, which that visual basic does nicely.
So yes, if you can use that code and modify it so that it gets all of the individual workbooks in one designated folder (I would use that same folder every time, so let's name the folder something like "consolidateme" :) and it makes all of those files into one new workbook -- with one worksheet in it containing the contents of the workbooks in that folder.
Whew! Did I over-explain that?
Thanks
I looked at that solution and yes I am using it when I have one workbook with multiple Worksheets in it. I run the Visual Basic to combine the multiple worksheets into one "consolidated " page, which that visual basic does nicely.
So yes, if you can use that code and modify it so that it gets all of the individual workbooks in one designated folder (I would use that same folder every time, so let's name the folder something like "consolidateme" :) and it makes all of those files into one new workbook -- with one worksheet in it containing the contents of the workbooks in that folder.
Whew! Did I over-explain that?
Thanks
ASKER
Hi broro183
I am looking at your link(s) now.
Thanks
Rowby
I am looking at your link(s) now.
Thanks
Rowby
ASKER
Thanks Rob,
RDB Merge worked great!
Rowby
RDB Merge worked great!
Rowby
ASKER
(And thanks, terencino, for your assistance too! )
hi Rowby,
I'm pleased I could help - thanks for the points :)
Rob
I'm pleased I could help - thanks for the points :)
Rob
ASKER
It's a great addon! Thanks for letting me know about it.
Command to combine many Excel files into one
...Terry