LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Add Page x of x based on sheets.

I have a document with about 40 sheets. Is there a way to have the
Page x of x be displayed on all sheet. But Page 1 should be sheet 1.
Page 2 should be Sheet 2 etc.

Let's go one more step.

Each sheet has 2 pages. Is it possible to have
Sheet 1, Page 1 to display Page 1 of 80
Sheet 1, Page 2 to display Page 2 of 80
Sheet 2, Page 1 to display Page 3 of 80
Sheet 2, Page 2 to display Page 4 of 80
Etc.

Thank you

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print sheets in Excel without blank sheets after page Peggy New Users to Excel 2 January 12th 08 11:10 AM
Printing 2 sheets on 1 page bparker Excel Discussion (Misc queries) 0 May 30th 06 03:43 PM
Print 3 sheets on the same page Revenger Excel Discussion (Misc queries) 3 January 18th 06 12:05 PM
populating sheets based on data from parent sheets seve Excel Discussion (Misc queries) 2 January 15th 05 09:22 PM
Printing 3 or more sheets into 1 page Dijiman Excel Programming 2 September 4th 04 02:40 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"