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./.
