Kelli Webb
Member
Hi,
I've got dynamic reporting working in my spreadsheet i.e. in the example below AK8 = S8/$AG$71 (2.73). But now in addition to todays result or the last day I've updated the report, they would like the actuals for each day saved across the spreadsheet i.e. 4/9/2017 for cc 40200 it would be 2.73
40201 it would be 0.27
I'm only focusing on the Primary results at this stage, just to get me going.
I wish I knew how to include a snapshot like below with the formulas, but because it's looking at a billion other tabs and reference material I wouldn't know where to start.
Any tips would be greatly appreciated.
I've got dynamic reporting working in my spreadsheet i.e. in the example below AK8 = S8/$AG$71 (2.73). But now in addition to todays result or the last day I've updated the report, they would like the actuals for each day saved across the spreadsheet i.e. 4/9/2017 for cc 40200 it would be 2.73
40201 it would be 0.27
I'm only focusing on the Primary results at this stage, just to get me going.
I wish I knew how to include a snapshot like below with the formulas, but because it's looking at a billion other tabs and reference material I wouldn't know where to start.
Any tips would be greatly appreciated.
