| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Consecutive Number (One spreadsheet) on Each Sheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing Consecutive Number (One spreadsheet) on Each Sheet
hello Ron,
This is a stupid question, how do I setup the input box? Scott... "Ron de Bruin" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing Consecutive Number (One spreadsheet) on Each Sheet
Ron,
I got it to work. How do I get it to add 1 to the current format? ..Range("I2").Value = CopieNumber & " workbook.add "1" Scott Senffner "Ron de Bruin" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing Consecutive Number (One spreadsheet) on Each Sheet
Ron,
I am using this one. I am now trying to format the cell with LR-01-000000 Thanks for all of your help. Scott Senffner "Ron de Bruin" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing Consecutive Number (One spreadsheet) on Each Sheet
Hi Scott
Use the Format function .Range("A1").Value = "LR-01-" & Format(CopieNumber, "000000") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Scott Senffner" wrote in message ... Ron, I am using this one. I am now trying to format the cell with LR-01-000000 Thanks for all of your help. Scott Senffner "Ron de Bruin" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I give consecutive numbers to a form when I'm printing it? | Excel Discussion (Misc queries) | |||
| Printing consecutive dates | Excel Discussion (Misc queries) | |||
| Can I auto number, serialize a spreadsheet for printing purposes. | Excel Discussion (Misc queries) | |||
| printing consecutive date on excel workbook | Excel Worksheet Functions | |||
| Printing Consecutive Numbers | Excel Programming | |||
Hybrid Mode
