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:
<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./.
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:
Parent | 2019 | 201901 | 201902 | 201903 | 201904 | . | . | . | . | . | . | . | 201912 |
2018 | 201801 | 201802 | . | . | . | . | . | . | . | . | . | 201812 | |
2017 | 201701 | 201702 | 201712 |
<tbody>
</tbody>
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./.