Automatic updating of reference page

[darkmirko]

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.

[oeldere]

You get better help on your question, if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html

[darkmirko]

Ok. I try to create an example.

I hope is it clear.

[oeldere]

I have seen your worksheet.

I has to be another worksheet each month?

Or is it also possible to make all countings on 1 worksheet (e.g. january)?

[darkmirko]

I have seen your worksheet.

I has to be another worksheet each month?

Or is it also possible to make all countings on 1 worksheet (e.g. january)?

another worksheet each month

Thank you for your consideration.