I have a spreadsheet that tracks my spending for the month. Right now I have a sheet for each month. Every month I make a new sheet that has some cell references linking it to the previous month particular cells. The way it is now, I have to manually change the sheet name that is referenced so that the correct months data will be displayed. I want to not have to manually change this every month. I would like to know if there is a formula that will link sheets and know to change with additional sheets.
Right now in the cell I have the following:
='April-10'!P4
I have to change the month and year (April-10), sheet name when I go to make a sheet for May. Thus it will look like this:
='May-10'!P4
I would like to not have to manually change the month and want to just copy and paste the sheet titled April-10 to another sheet named May-10 and this update will already be done.
This will have to work for June-10 sheet and July-10 sheet and so on.
If anyone knows please help.
Bookmarks