Attached is my Dummy Data: forum.ozgrid.com/index.php?attachment/56139/
My Input data is in the "Report" tab.
And my desired output is "Unit Performance" tab.
Currently I have employed formulas to get to the desired results.
However, the limitation is that the input data keeps expanding both in terms of months as well as accounts. And therefore extending the formula is error prone and cumbersome.
Can someone suggest how I can achieve this result directly via VBA?
Guidelines as below:
Computing Revenue --> Sum of "Total Revenue" column by Account and by Month
Computing C&B --> Total of Sums of columns "Salary Total", "Sub con Total", "CXU Buffer cost", "CXD Buffer cost", "Group Buffer cost" divided by Revenue computed above as a percentage rounded to zero.
Computing EBIDTA --> Sum of "EBIDTA" column by Account and by Month divided by Revenue computed above as a percentage rounded to zero.
Quarter results are quarter totals divided by quarter revenues.