ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can i print 1 page many times with diferent reference number ? (https://www.excelbanter.com/excel-discussion-misc-queries/60760-how-can-i-print-1-page-many-times-diferent-reference-number.html)

Sixto Valenzuela

How can i print 1 page many times with diferent reference number ?
 
i want to print a single page where i have a number 0001 and each time i
print i want it to change in secuence like this 0002, 0003 ?

thank you

Bernie Deitrick

How can i print 1 page many times with diferent reference number ?
 
Sixto,

You could use a macro... If your number is in cell A1:

Sub PrintOut100Copies()
For i = 1 To 100
Range("A1").Value = Range("A1").Value +1
ActiveSheet.PrintOut
Next i
End Sub

HTH,
Bernie
MS Excel MVP


"Sixto Valenzuela" <Sixto wrote in message
...
i want to print a single page where i have a number 0001 and each time i
print i want it to change in secuence like this 0002, 0003 ?

thank you




Ron de Bruin

How can i print 1 page many times with diferent reference number ?
 
Hi Sixto

Try
http://www.rondebruin.nl/print.htm#number


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sixto Valenzuela" <Sixto wrote in message
...
i want to print a single page where i have a number 0001 and each time i
print i want it to change in secuence like this 0002, 0003 ?

thank you





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com