I'm using MS excel template to make invoices. To make my work easier I want excel template to generate automatic serial number everytime I make new invoice. Automatic serial number means unique invoice number each number.
I'm using MS excel template to make invoices. To make my work easier I want excel template to generate automatic serial number everytime I make new invoice. Automatic serial number means unique invoice number each number.
You'll need VBA to generate the sequencial invoice numbers.
JE McGimpsey has the generally accepted best approach.
See his website:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks