aravindhan_31
Well-known Member
- Joined
- Apr 11, 2006
- Messages
- 672
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi,
I need your help again, I have some 25 files in a folder like File1,File1,File3,File4 etc. each file has many sheets, I am trying to create a new master file from the sheets of these files.
I take some sheets from these 20 files and create my master file.
everytime I open each and every file move sheets to my master file then do a copy paste values.
Is there a way in macro where I will give all 20 file names with the path and the sheet names from those file on the code so each time I run the macro the sheets are imported to my master file.
I have attached a excel file with details.
Cross post: http://www.excelforum.com/excel-pro...ort-specific-sheets-with-value-in-a-file.html
I need your help again, I have some 25 files in a folder like File1,File1,File3,File4 etc. each file has many sheets, I am trying to create a new master file from the sheets of these files.
I take some sheets from these 20 files and create my master file.
everytime I open each and every file move sheets to my master file then do a copy paste values.
Is there a way in macro where I will give all 20 file names with the path and the sheet names from those file on the code so each time I run the macro the sheets are imported to my master file.
I have attached a excel file with details.
Cross post: http://www.excelforum.com/excel-pro...ort-specific-sheets-with-value-in-a-file.html