View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Printing Consecutive Number (One spreadsheet) on Each Sheet

hi Scott

See this page for a example
http://www.rondebruin.nl/print.htm#same

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scott Senffner" wrote in message
...
I am looking for help in configuring a printed form. I have a basic form in
excel that has a number in the upper right hand corner that needs to change
when I print multiple copies. Say the number is LR-01-000025. I want to go
to Print, copies, 100.

I want the number to change from LR-01-000025 to LR-01-000026, LR-01-000027
... to LR-02-000125.

Your help would be greatly appreciated.

Scott Senffner