Automatic Page Number and Sheet Names?
 

Hello!
Im curious to find out if it's possible to insert the page numbers & sheet
names of other sheets into a table which summarizes all the sheets.
for example:
summary sheet:
page # Sheet Name ...Other Calculated numbers...
1 sheet1 ###
2-3 sheet2 ###
4 sheet3 ###
5-10 sheet4 ###

whe sheet1 will print out on 1 page, sheet2 on 2 pages, etc. - depending
on page breaks

hopefully this won't include me manually inserting any numbers or names.

Any help?
Thanks,

Automatic Page Number and Sheet Names?
 

I am unsure if I understand but (ignoring all the page stuff):
If I have in B1 of the summary sheet the text: Sheet2
and in C1 the formula =SUM(INDIRECT("'"&B2&"'!A1:A10"))
that is =SUM(INDIRECT( double-quote singe-quote double-quote &B2&
double-quote sing-quote A1:A10 double-quote))
Then C1 displays the sum of the numbers in A1:A10 of Sheet2
Any help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Derrick" wrote in message
...
Hello!
Im curious to find out if it's possible to insert the page numbers & sheet
names of other sheets into a table which summarizes all the sheets.
for example:
summary sheet:
page # Sheet Name ...Other Calculated numbers...
1 sheet1 ###
2-3 sheet2 ###
4 sheet3 ###
5-10 sheet4 ###

whe sheet1 will print out on 1 page, sheet2 on 2 pages, etc. -
depending
on page breaks

hopefully this won't include me manually inserting any numbers or names.

Any help?
Thanks,

Automatic Page Number and Sheet Names?
 

not really. sorry.

I'm trying to make an index of sorts, so that when i do a print preview,
and/or print the workbook, the page numbers of the printed sheets will be
listed in the summary table - for easy reference for the reader.
- Basically if i change the page crop lines, i would like it to register
how many pages from each sheet are going to be printed, and number them from
1-??
- i can get the names from a "title" cell from the other sheets, so that's
not a problem.

"Bernard Liengme" wrote:

I am unsure if I understand but (ignoring all the page stuff):
If I have in B1 of the summary sheet the text: Sheet2
and in C1 the formula =SUM(INDIRECT("'"&B2&"'!A1:A10"))
that is =SUM(INDIRECT( double-quote singe-quote double-quote &B2&
double-quote sing-quote A1:A10 double-quote))
Then C1 displays the sum of the numbers in A1:A10 of Sheet2
Any help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Derrick" wrote in message
...
Hello!
Im curious to find out if it's possible to insert the page numbers & sheet
names of other sheets into a table which summarizes all the sheets.
for example:
summary sheet:
page # Sheet Name ...Other Calculated numbers...
1 sheet1 ###
2-3 sheet2 ###
4 sheet3 ###
5-10 sheet4 ###

whe sheet1 will print out on 1 page, sheet2 on 2 pages, etc. -
depending
on page breaks

hopefully this won't include me manually inserting any numbers or names.

Any help?
Thanks,