Sequential Numbering of Invoices when Printing

[WarrenC]

I am building an invoice and I need to sequentially number them as they print. I was thinking of using the page number feature, but I cant figure out how to get it into a specific cell. So if I decide to print a hundred invoices, they come off the printer No 1, No 2, No 3 etc. Again, I need this in a specific cell. Can this be done???

[oldchippy]

May be this link will help?

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

[WarrenC]

found some vb code on the net and got it working. Thanks to all

Please Login or Register  to view this content.

As long as your sheet is called Summary, the numbers in cell A1 change everytime you print (or print preview)

[jkhayes]

How about sharing an example of what it looks like?

[shg]

Warren, please wrap the code in your post with code tags. If you don't know how, please read the forum rules.