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...
if you want to automate your budget,I am afraid you have to save your data in layout like below:
| amount | debit | credit | checked |
| 100 | Checking | Student Loan | 2023-12-24 22:19:40-65883dfc7ef15 |
| 200 | Checking | Home Loan | 2023-12-25 07:28:35-6588bea375e68 |
| 100 | a | Home Loan | 2023-12-28 17:15:10-658d3c9e3c7f4 |
then generate summary reports as your images rather than directly save all datas in report which may not be easy to handle by computer.