I have several workbooks with several sheets in a folder C:\\summarydata (around 50 workbooks)
focus to copy only specific sheets in these workbooks named worksheet CUSTOMER A. to a new sheet.(that is summarise all customer A sheet on one sheet)
All customerA sheets has same format and headers from column A to AF then AJ TO AO.
There are some headers who have blank column
Note that all workbooks folder are closed
This macro assumes that your source files all have an "xlsx" extension (in red) and that they are the only files in your folder.
Please Login or Register to view this content.
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.
Tried code but getting compile error message , variable not defined
strExtension in yellow
Do your source files have an "xlsx" extension?
yes, I have put the code in a blank workbook
Last edited by JEAN1972; 01-27-2019 at 01:07 PM. Reason: typo
I tested the macro and it worked properly. Check the folder path--- C:\summarydata
Still same issue
create a new directory as c:\ss\ with files in it
change parameter, still same issue
Last edited by JEAN1972; 01-27-2019 at 01:56 PM. Reason: typo
Try:
Please Login or Register to view this content.
Thank you this one works .
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks