J
jim sturtz
i have a spreadsheet that i would like to do the following with:
...have a spreadsheet with say 30 pages, each page labeled with a month/dom,
ie May1,May2,...May30. Each page has 30,31,28,29 days as rows and then
several columns days but of course the rows vary depending on the month.
Now lets say I know there will be a june, july, etc sheet. I want a formula
to put on each page that is the sum of column j on each page. In the unique
case I can refer to mayx-cellx by a link like "='May 9'!$M$26", but I would
like a generic statement that doesn't care if it is May9, or Jun9, or xyz,
just the 9th page of the sheet. Is there a dual-refernce to a page within a
sheet so you don't have to use the 'name', but you can reference to the
page_position within the whole spreadsheet. Just like a cell can be named as
a var, but it is also j55.
thanks.
jim
microsoft.public.excel.newusers
...have a spreadsheet with say 30 pages, each page labeled with a month/dom,
ie May1,May2,...May30. Each page has 30,31,28,29 days as rows and then
several columns days but of course the rows vary depending on the month.
Now lets say I know there will be a june, july, etc sheet. I want a formula
to put on each page that is the sum of column j on each page. In the unique
case I can refer to mayx-cellx by a link like "='May 9'!$M$26", but I would
like a generic statement that doesn't care if it is May9, or Jun9, or xyz,
just the 9th page of the sheet. Is there a dual-refernce to a page within a
sheet so you don't have to use the 'name', but you can reference to the
page_position within the whole spreadsheet. Just like a cell can be named as
a var, but it is also j55.
thanks.
jim
microsoft.public.excel.newusers