Hi all,
I have workbook Main.xlsx with 03 sheets(main, sum_A1, copytolastrow_A2). Please help me create 02 macro brown to folder to do: 01 macro sum from multiple wb and 01 macro copy from multiple wb that:
1. Macro SUM:
Brown to special and sum all file .xl* - sheet(A1) - range(A5:E6) to sheet(sum_A1).range(A5:E6)
2. Macro Copy:
Brown to special and copy all file .xl* - sheet(A2) - range(A2:E2) to sheet(copytolastrow_A2)
All source file have the same structure like this:
sheet(A1)
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
sheet(A2)
<tbody>
</tbody>
And in workbook Main.xlsx have result like this:
sheet(sum_A1) ==> I examble sum 3 files, actualy folder have more than 15 files
<tbody>
</tbody>
sheet(copytolastrow_A2)
<tbody>
</tbody>
Some one please help me, thanks./.
I have workbook Main.xlsx with 03 sheets(main, sum_A1, copytolastrow_A2). Please help me create 02 macro brown to folder to do: 01 macro sum from multiple wb and 01 macro copy from multiple wb that:
1. Macro SUM:
Brown to special and sum all file .xl* - sheet(A1) - range(A5:E6) to sheet(sum_A1).range(A5:E6)
2. Macro Copy:
Brown to special and copy all file .xl* - sheet(A2) - range(A2:E2) to sheet(copytolastrow_A2)
All source file have the same structure like this:
sheet(A1)
1 | 1 | 1 | 1 |
1 | 1 | 1 | 1 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
sheet(A2)
1 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>
And in workbook Main.xlsx have result like this:
sheet(sum_A1) ==> I examble sum 3 files, actualy folder have more than 15 files
A | B | C | D | E | F | |
1 | ||||||
2 | ||||||
3 | ||||||
4 | ||||||
5 | 3 | 3 | 3 | 3 | 3 | |
6 | 3 | 3 | 3 | 3 | 3 |
<tbody>
</tbody>
sheet(copytolastrow_A2)
A | B | C | D | E | |
1 | |||||
2 | 1 | 1 | 1 | 1 | 1 |
3 | 1 | 1 | 1 | 1 | 1 |
4 | 1 | 1 | 1 | 1 | 1 |
5 |
<tbody>
</tbody>
Some one please help me, thanks./.