Hey,
I am trying to copy a tab from multiple excel files into one master workbook. Here the specifications;
1) marco needs to copy a tab from the excel file and paste value in the masterwork book. For the next excel file it copies, move it to new tab in the master workbook and so on for the next.
Note that there are 20 excel files in the directory and the name of the files are the same and the tab name to copy same as well.
Can anyone help with this request?
1) There can't be two files in the same directory with the same name, so I think you've misstated there.
2) The sheet IN those files can be the same name and can be renamed prior to import, no problem there.
-------------
'WORKBOOKS TO SHEETS
Here's a macro for collecting data from all files in a specific folder. This version copies the sheet in as a whole.The parts of the code that need to be edited are colored to draw your attention.
-------------------
That should get you most of the way there. The one tweak based on your goal to have no formulas in the copied sheets....this section:
Possibly change to this:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-26-2019 at 04:26 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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks