Printing Consecutive Number (One spreadsheet) on Each Sheet

  • Thread starter Thread starter Scott Senffner
  • Start date Start date
S

Scott Senffner

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
 
hello Ron,

This is a stupid question, how do I setup the input box?

Scott...
 
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,

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
 
Hi Scott

Use the Format function

.Range("A1").Value = "LR-01-" & Format(CopieNumber, "000000")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code copies ONLY last j from sheet 9
Copy Data from one sheet to many based on column A 7
Copy row from one sheet to one of many others 6
print 2 sheets on one paper 5
Consecutive print numbers 3
Getting values from desired sheet for printing. 5
Printing userform in landscape on one page only 2
Printing Consecutive Numbers 2

Back
Top