I need a vba code to copy multiple columns from sheet1 and paste as list in sheet2
Here is current data format in sheet1
<tbody>
</tbody>
New format in sheet2 -list
<tbody>
</tbody>
Here is current data format in sheet1
H | G | H | I | J | K | L | M | |
16 | 001/2018 | 002/2018 | 003/2018 | |||||
17 | 8000 | 9000 | 9500 | |||||
18 | London | NewYork | Paris | |||||
19 | GL acct | Name | Plan | Actual | Plan | Actual | Plan | Actual |
20 | 1000 | Salary | 500 | 450 | 500 | 400 | 500 | 390 |
21 | 1001 | Travel | 150 | 135 | 150 | 120 | 150 | 117 |
22 | 1002 | Meal | 50 | 45 | 50 | 40 | 50 | 39 |
<tbody>
</tbody>
New format in sheet2 -list
Date | Site no | Site | GL acct | Name | Plan | Actual | |
001/2018 | 8000 | London | 1000 | Salary | 500 | 450 | |
001/2018 | 8000 | London | 1001 | Travel | 150 | 135 | |
001/2018 | 8000 | London | 1002 | Meal | 50 | 45 | |
002/2018 | 9000 | NewYork | 1000 | Salary | 500 | 400 | |
002/2018 | 9000 | NewYork | 1001 | Travel | 150 | 120 | |
002/2018 | 9000 | NewYork | 1002 | Meal | 50 | 40 | |
003/2018 | 9500 | Paris | 1000 | Salary | 500 | 390 | |
003/2018 | 9500 | Paris | 1001 | Travel | 150 | 117 | |
003/2018 | 9500 | Paris | 1002 | Meal | 50 | 39 |
<tbody>
</tbody>