Page Numbers/Names listed on a Summary sheet?
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,
|