Hi everyone! I need of a little help here
I created a excel file for my accounting with an excel page for every month.
In order to do a sort of checking of my money, in many cells, I put a subtraction among two cells of two different pages.
I mean:
I have the page of February and the page of March. Now, in March I put a subtraction formula among the total of my money (in march) and the total of february.
I see something like this: February!N7-March!N7. (in a lot of cells)
My problem comes now. When I create a new page (for April), I copy the last page (in this way I don't have to reformat every text, cell etc.) but, I have to manually change the cells for modify the reference of the month.
I have: February!N7-March!N7 but I want March!N7-April!N7.
Just a sort of updating over and over.
Is that possible?
Thank you very much!
My apologies for the english.
Bookmarks