How can I restructure Cashflow Plans reports to include additional variables?
One solution would be to work through the various reports making changes to formulae as required. Obviously, this has to be done with great care to ensure that the integrity of Cashflow Plan is not disrupted. Another approach would be to (i) copy the contents of output reports into empty rows on their respective worksheets using simple cell references (like “=A16”), (ii) copy and paste (use Paste Special … Formats) the original reports’ formatting into the new reports and (iii) make all the desired changes within the copied reports. Although, it requires setting up, this approach may be more expedient in the long run as the underlying Cashflow Plan model is not disrupted and changes should be much easier to apply and be more evident.
