How can I combine multiple workbook into master

sbv1986

Board Regular
Joined
Nov 2, 2017
Messages
74
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./.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,090,102
Messages
5,412,435
Members
403,427
Latest member
mese0115

This Week's Hot Topics

Top