Hi Guys,
I am looking for a solution to an issue.
I have uploaded a sample workbook which shows the desired output (much easier than explaining) however, here is a brief explanation of the issue
At any time of the month I export the data seen in A1:B83 from one of our systems.
Col B figures are "Actual" figures which should populate the Actual rows in the Drill Down Tab
I am looking for a quick efficient way of copying the data to the correct position in the Drill Down Tab
Currently I have to copy and paste special transpose values from the range B2:B83 into various ranges in the Drill Down tab.
eg B2:B13 gets transposed to Drill Down range E10:P10
B16:B27 gets transposed to Drill Down range D20:O20 and so on... some products may not have data for some months eg Water & waste treatment currently has no data for May
I have to do this for all 6 products (highlighted in blue)
Can anyone recommend a way of achieving this using a formula or code?
Many thanks for you time
Bookmarks