Assigning unique serial number

  • Thread starter Thread starter byudantheman
  • Start date Start date
B

byudantheman

Is there any way that you can assign a unique serial or form number with each
copy of something I print off? For example, if I have an invoice that I
print off 10 copies of, I want each copy to have a unique number in a cell.
Then the next time I open the program, I want it to continue counting. Any
ideas?
 
See Ron de Bruin's site for code to do exactly what you want when printing,
inclucing the "come back later and start from where you left off"

http://www.rondebruin.nl/print.htm#same

For simply assigning a new number each time you open the workbook see Jim's
posting.


Gord Dibben MS Excel MVP
 
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

serial numbers in worksheet invoices 1
Unique entries based on condition - count distinct 1
Quick way merge 2 databases using a unique field. 2
How can I iterate numbering when printing 1
form serial number 2
Make an Excel cell create a new sequential number each printing 1
Data Lookup Question 1
Pivot tables - counting unique numbers 2

Back
Top