I have an existing project report that has two lines per project - revenue and cost.
My boss wants a more detailed report which means that each project now has five lines of analysis.
The problem is that the existing report is wo be used as a summary. There are potentially 100 projects and I need a macro that will reference from the summary back to the detail.
I need a loop that starting at row 1 it will put in a formula in B1 that equals the sum of ("B1:B2") on the detail sheet then B2 will equal B5 on the detail sheet.
I will then use the offset command to move to the next row but am struggling to get it to pick up the data from the correct rows 7:9 and 12 in the first instance.
This needs to be done by way of formulas linking to the other sheet rather than pivot tables or similar solutions.
Any suggestions?
My boss wants a more detailed report which means that each project now has five lines of analysis.
The problem is that the existing report is wo be used as a summary. There are potentially 100 projects and I need a macro that will reference from the summary back to the detail.
I need a loop that starting at row 1 it will put in a formula in B1 that equals the sum of ("B1:B2") on the detail sheet then B2 will equal B5 on the detail sheet.
I will then use the offset command to move to the next row but am struggling to get it to pick up the data from the correct rows 7:9 and 12 in the first instance.
This needs to be done by way of formulas linking to the other sheet rather than pivot tables or similar solutions.
Any suggestions?