Need to slightly re design the following workbook......
1. Amend VBA Code worksheet "Cashflow Yearly"....
need to the macro to remain the same OTHER than remove the part of generating the same forumla in each section i.e. see hightlighted....in yellow as to worksheet "Cashflow Q4".....
so that know when the macro is run the formula in cell F6 is = CashFlow Q4$F$6
and NOT that longer array formula currently in there at the moment...........
Looking at way to simplify the workbook.........