Automatic Page Number and Sheet Names?

D

Derrick

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 ###

where: 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,
 
B

Bernard Liengme

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
 
D

Derrick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top