MrExcel Publishing
Your One Stop for Excel Tips & Solutions

numbering invoices

Posted by pepper on November 22, 2001 4:32 PM

How do you number a spreadsheet so the client can print off hundreds and have them sequentially numbered? I've spent hours and hours trying to figure this one out. I'd appreciate any direction.

Posted by peter on November 22, 2001 10:36 PM

write a VBA code that before you print it updates the invoicenum to invoicenum+1 (you can also set this to worksheet open function.)
Use the Workbook_BeforePrint for this.

Then Have another macro that calls the print command a number of times (get vba to ask you how many times you need to print then loop the print function for this many times) and attach it to a command button.

Would be good to put a slight wait statement to slow down the printing routine as it may overload the printer queue.

Posted by pepper on November 23, 2001 2:17 PM

Thank you so much, Peter!