Hi.
Twice a year i have a task that i hope can be simplified. I'll just show the input and show how it should look at the end
My working budget file has about 40 tabs (each tab represents a different Cost Center).
Each tab if formatted exactly the same way (fig 1)
Each cost center has 117 accounts
My goal is to highlight data in Fig 1 ie (A9:O126)
Fig 1
<tbody>
</tbody>
I need to transpose data for each tab to Fig 2
Fig 2
<tbody>
</tbody>
Twice a year i have a task that i hope can be simplified. I'll just show the input and show how it should look at the end
My working budget file has about 40 tabs (each tab represents a different Cost Center).
Each tab if formatted exactly the same way (fig 1)
Each cost center has 117 accounts
My goal is to highlight data in Fig 1 ie (A9:O126)
Fig 1
Account | Description | Cost-Center | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
4005 | Labour | 423 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 |
4130 | Services | 423 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |
4280 | Rent | 423 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 |
4320 | Material | 423 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |
<tbody>
</tbody>
I need to transpose data for each tab to Fig 2
Fig 2
Account | Cost-Center | Period | Amount |
4005 | 423 | 1 | 10000 |
4005 | 423 | 2 | 10000 |
4005 | 423 | 3 | 10000 |
4005 | 423 | 4 | 10000 |
4005 | 423 | 5 | 10000 |
4005 | 423 | 6 | 10000 |
4005 | 423 | 7 | 10000 |
4005 | 423 | 8 | 10000 |
4005 | 423 | 9 | 10000 |
4005 | 423 | 10 | 10000 |
4005 | 423 | 11 | 10000 |
4005 | 423 | 12 | 10000 |
4130 | 423 | 1 | 1000 |
4130 | 423 | 2 | 1000 |
4130 | 423 | 3 | 1000 |
4130 | 423 | 4 | 1000 |
4130 | 423 | 5 | 1000 |
4130 | 423 | 6 | 1000 |
4130 | 423 | 7 | 1000 |
4130 | 423 | 8 | 1000 |
4130 | 423 | 9 | 1000 |
4130 | 423 | 10 | 1000 |
4130 | 423 | 11 | 1000 |
4130 | 423 | 12 | 1000 |
etc |
<tbody>
</tbody>