I'm a relative novice at XL; that is I can do basic stuff, create and format spreadsheets and to basic stuff inside a single sheet, but haven't tried connecting data between sheets.
I created an itemized, monthly budget sheet and every month I copy the previous month's sheet, rename it, clear the data and start over.
The reason I don't create a whole year is because I keep tweaking the current sheet in the workbook, if I thought I could tweak them into the future, as a group, I would make a 12 month workbook.
Right now II want to create a new column in my monthly sheet with the averaged monthly totals for each expense; starting with Jan.
For example:
Ave I9; which is the sum(B9:H9, B10:H10), from sheets Jan, Feb, March, April, May, and June and place the result into H9 of the July sheet.
That is probably simple enough, (when I learn the formula to get the data from outside the current sheet) but what about the next months sheet?
Is it possible to create a formula that would add the I9 cell for the previous month to the new month's sheet; when I create the new sheet for that month? Of course I wouldn't delete the data in column I9 when I create the new sheet.
Is it possible to tweak sheets as a group? Like, if I wanted to add a column in July and have it affect the rest of the year? That would make it possible to create a workbook with 12 sheets.
I would still have the issue with ave from the current month, as I move ahead in time; maintaining the averages for each consecutive month.
btw Can you create a spreadsheet and multiply it 12 times? Or would I have to make copies, 12 times?
Start Free Trial
