Referencing cells on other pages

S

Simon Jones

Its easy to include cells from other pages in my calculations. That is not my
question. What I'd like to do is access cells on the previous page. To
clarify, I have a template that forms the basis of my monthly budgeting. I'd
like to create a new page in my workbook with this template and the link
automatically references the previous page. So if I create a new page and put
it in next to the 'Nov'05' the link will automatically reference that page.
If I stick my new page next to 'Oct'05' it will automatically reference that
page and so on.....

Is this possible? Is there generic page references or is the page reference
done purely on the page name?

I could imagine putting in an equation something like

=document.info.pagenumber-1

Or something like that?

Any ideas?
 
Top