Auto Generate Sequential Invoice Number

**jneldon** · 03-09-2009, 01:14 PM

I have an "invoice" template that I have created. Each time I open the template I would like Excel to auto generate a sequential invoice number. For example, when I open the template I would like it to assign invoice number "A-431". I will fill out the invoice and save it as a worksheet. The next time I open the template it should assign invoice number "A-432". Is this possible?

**royUK** · 03-09-2009, 01:17 PM

You will need to use VBA to do this, the number store needs to be stored somewhere, it could be a text file or in the registry. Which would be best for you?

Auto Generate Sequential Invoice Number

LinkBack

Thread Tools

Rate This Thread

Display

Auto Generate Sequential Invoice Number

Re: Auto Generate Sequential Invoice Number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions