ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I print a new number on each page (https://www.excelbanter.com/excel-worksheet-functions/7636-how-do-i-print-new-number-each-page.html)

AJ Perkins, Wales, UK

How do I print a new number on each page
 
Is there a formula that I can use so that when I print, depending on the
number of copies I do it will add that number.

What I have is a booking form, and each form has to have a new number (eg
A5643, A5644) at the moment I am having to write the number on by hand which
is time consuming when you have over 200 a week to do, so is there a code I
can put in which will automaticly generate a new code when I print,. So if I
have A5643 in, and print out 100 copies, it will automaticly add a new number
to each print.

Thanks in advance for any help!!

AJ

Ron de Bruin

Hi AJ Perkins

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


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


"AJ Perkins, Wales, UK" <AJ Perkins, Wales, wrote in message
...
Is there a formula that I can use so that when I print, depending on the
number of copies I do it will add that number.

What I have is a booking form, and each form has to have a new number (eg
A5643, A5644) at the moment I am having to write the number on by hand which
is time consuming when you have over 200 a week to do, so is there a code I
can put in which will automaticly generate a new code when I print,. So if I
have A5643 in, and print out 100 copies, it will automaticly add a new number
to each print.

Thanks in advance for any help!!

AJ





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

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