Is there anyway to create a worksheet with some formulas, subtotals, % variable, max etc, where the formulas are kept but figures updated on a monthly basis?
A report with approximately 16 cols and 50 rows, imported from an accounting package provides the monthly figures; the report does not give me the stats I need.
I had hoped that by exporting the report to excel and linking the report spreadsheet named “cash flow” to a spreadsheet with the formulas named “formulas” I could just keep updating it.
As soon as I remove e.g. July’s “cash flow” spreadsheet rename it e.g. to “cash flow July” then replace it with August’s “cash flow” my formula page wants to stay linked to the renamed “cash flow July” and I can’t cut the link to July and link it to new August spreadsheet “cash flow”
Am I doing this all wrong??
A report with approximately 16 cols and 50 rows, imported from an accounting package provides the monthly figures; the report does not give me the stats I need.
I had hoped that by exporting the report to excel and linking the report spreadsheet named “cash flow” to a spreadsheet with the formulas named “formulas” I could just keep updating it.
As soon as I remove e.g. July’s “cash flow” spreadsheet rename it e.g. to “cash flow July” then replace it with August’s “cash flow” my formula page wants to stay linked to the renamed “cash flow July” and I can’t cut the link to July and link it to new August spreadsheet “cash flow”
Am I doing this all wrong??