Natsha
New Member
- Joined
- May 20, 2021
- Messages
- 44
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi all,
I need an macro to browse an Folder and it has subfolder as eg: may 1 ,may 2, may 3 ... And each folder has 1 to 5 files, the file numbers may vary some time it have 1 to 4 , it depends..but all workbook has only one sheet and all are in same alginnment . I want my macro to go to an folder and copy all sub folder may 1,2,3,4 and all the workbooks sheet 1 to be pasted in sheet 2 of my macro workbook. Also I want first row in all the workbooks to be removed.
Example
Folder
Subfolder: may 1,may 2... Etc
May1; 1 to 5 workbooks and data's are there only in sheet1 ,also first row of all the workbooks should be removed .
I need an macro for this... It will be really helpful if anyone help. Tq
I need an macro to browse an Folder and it has subfolder as eg: may 1 ,may 2, may 3 ... And each folder has 1 to 5 files, the file numbers may vary some time it have 1 to 4 , it depends..but all workbook has only one sheet and all are in same alginnment . I want my macro to go to an folder and copy all sub folder may 1,2,3,4 and all the workbooks sheet 1 to be pasted in sheet 2 of my macro workbook. Also I want first row in all the workbooks to be removed.
Example
Folder
Subfolder: may 1,may 2... Etc
May1; 1 to 5 workbooks and data's are there only in sheet1 ,also first row of all the workbooks should be removed .
I need an macro for this... It will be really helpful if anyone help. Tq