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

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

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

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

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

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