I have a lot of files with same header range in a c drive: folder called consolidate order.
Looking for macro to copy all file data and to merge them in single mastersheet workbook. on my desktop
All workbook on c:drive folder consolidate order have a single sheet.
See attached samples of orders to merge on single workbook
Take note that these files can be of 3000 rows of data or more
Thanks if any one can help
Do you want the data from all the workbooks on one sheet in the Master workbook or on separate sheets?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
This will do it, make note of the highlighted parts you might want to edit:
Please Login or Register to view this content.
Last edited by JBeaucaire; 09-30-2016 at 12:40 PM.
_________________
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!)
Thank you ,works as requested .
Save me from a tedious task
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Masterworkbook on one sheet onlyOriginally Posted by Mumps1
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