Hi everyone,
I found the below macro that lets me select specific files in a folder and combines them all on one sheet. What I need now is for the same thing to combine them into a new workbook but as separate sheets. I'm guessing it's just a matter of changing part of this but I'm not sure what should be changed or what it should be changed to.
Thanks in advance.
'
Please Login or Register to view this content.
Last edited by JBeaucaire; 08-29-2013 at 12:45 PM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.
Perhaps as simple as changing this section:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon 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!)
That seems to have done the trick, unfortunately the server at my office just went down so I can't test it on what I need it for but thank you very much for your help and quick response.
Originally Posted by JBeaucaire
Perhaps as simple as changing this section:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks