How can I combine multiple workbook into master

sbv1986

Board Regular
Joined
Nov 2, 2017
Messages
72
Hi all:
I have Folder Parent with child folder: 2019, 2018, 2017. Each folder have child folder too: 201901,201902,201903,201904.....201912
It's look like:
Parent2019201901201902201903201904.......201912
2018201801201802.........201812
2017201701201702201712

<tbody>
</tbody>
I have master workbook in Parent folder: master.xlsm
Now I want to have 02 macro to do that:
Macro1. List all folder, includesub Folder in Parent folder and Create check box for each folder in list
Macro2. When I click check box and run this macro it will combine all files like G001*.xlsx, range(A10:I24) into workbook(master).sheet(G001)
and combine all files like A001*.xlsx, range(A2:AA50) into workbook(master).sheet(A001)

Please help me to do that, many thanks./.
 

Forum statistics

Threads
1,078,240
Messages
5,339,038
Members
399,275
Latest member
amrita17170909

Some videos you may like

This Week's Hot Topics

Top