Forum Discussion
Copying a formula to adjust the cell range automatically.
I am creating a budgeting spreadsheet. On the master list I have a formula created (*See first picture) to sum amounts in the other tabs according the category they are placed in. I want to copy this...
Your work sheet needs to be completely redesigned.
Its not using the full capabilities of Excel. [Tables, array functions etc.,]
Its quite a static design.
Without sample data the community will not be effectively help you.