I need code which can copy data in multiple sheets and paste in a master sheet. I actually have ~500+ sheets which need to be pasted (accumulated at one place)
My excel looks some thing like this.
SHEET 1
<tbody>
</tbody>
SHEET2
<tbody>
</tbody>
and the MASTER SHEET shouid be like .
<tbody>
</tbody>. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
If some one could help me out there........
My excel looks some thing like this.
SHEET 1
Slno | name | marks |
1 | asd | 455 |
6 | gfs | 3254 |
7 | rgf | 252 |
3 | hjf | 212 |
<tbody>
</tbody>
SHEET2
Slno | name | marks |
4 | ads | 110.5 |
5 | akj | 262.6 |
9 | yut | 635.7 |
2 | bmb | 1008.8 |
<tbody>
</tbody>
and the MASTER SHEET shouid be like .
Slno | name | marks |
1 | asd | 455 |
6 | gfs | 3254 |
7 | rgf | 252 |
3 | hjf | 212 |
4 | ads | 110.5 |
5 | akj | 262.6 |
9 | yut | 635.7 |
2 | bmb | 1008.8 |
<tbody>
</tbody>
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
If some one could help me out there........
Last edited: