LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default How do I print a one page spreadsheet multiple time, each with its own page number?

Hello:

I have a one page spreadsheet, essentially a template. I would like to be able to print as many copies as needed, but each copy has to print a unique sequence value, which increments by one every time it is printed.

This variable may require some formatting, but it's somewhat like a page number. Printing multiple copies is just reprinting page one to Excel; each page is labeled 1. I'd rather not copy my print range x number of times into the workbook, but that's what I did, just to get started. I don't have any VB experience; I was just trying to use Excel's existing functionality.

Thank you,

Laura Sallwasser
 
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
Print multiple tabs on one page excelQ Excel Discussion (Misc queries) 2 July 7th 05 02:38 PM
print multiple copies of the same page with sequential numbers labrat Excel Discussion (Misc queries) 1 June 14th 05 05:32 PM
One spreadsheet cell won't print but shows up in print preview? Sally Excel Discussion (Misc queries) 1 May 26th 05 07:06 PM
Print ascending number on multiple printed cpoies cbwood Excel Discussion (Misc queries) 0 May 25th 05 11:08 PM
How can I print long lists of data from an Excel spreadsheet? sonic_d_hog Excel Discussion (Misc queries) 1 December 22nd 04 09:31 PM


All times are GMT +1. The time now is 07:51 AM.

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

About Us

"It's about Microsoft Excel"