Using sequential numbers

**Rhonda F** · 08-21-2007, 12:37 AM

Hello All,
I have another question and it is about using sequential numbers as an invoice number. I found the following code at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Please Login or Register  to view this content.

Could someone explain it (line by line) to me so that I can understand what it is suppose to do?

Thank you in advance for your time and patience as I am learning.

Rhonda

**Leith Ross** · 08-21-2007, 01:49 AM

Hello Rhonda,

There is a simpler and more secure way to handle your invoice numbers. Have a look at the code I wrote for another poster who was doing this with an Excel template.

Automatic Invoice Numbering

Sincerely,
Leith Ross

**royUK** · 08-21-2007, 02:55 AM

Leith's suggsetion stores the number in the registry, which is fine. However, it isn't available if you are using another computer.

This is another way that stores the number in a Name, for a full explanation of using Names in Excel read Bob Phillips article here

http://www.xldynamic.com/source/xld.Names.html

To use this you must be using a workbook template, ie a master copy that you save copies of. I usually have a database built in for storing invoice data, etc.

This code will add a name that stores your unique number

Please Login or Register  to view this content.

**royUK** · 08-21-2007, 09:18 AM

No wonder you are getting conused. Not only are you asking virtually the same question in two Forums

http://www.ozgrid.com/forum/showthre...d=1#post384281

You are mixing your answers & responding to the wrong question

**Rhonda F** · 08-21-2007, 09:57 AM

Thank you all for responding, but I do not want to use this code, I just want to understand what is happening on each line of code.

I am working on another forum with incremating an invoice number, and do not want to use the code that is in my first post here, I just want to understand it.

I am sorry royuk, I just wanted to understand this code for maybe a future use...not now, I am still too new.

Again, Thank you all for responding and royuk, please forgive me I will not do this again.

Rhonda

**royUK** · 08-21-2007, 12:32 PM

Rhonda, it's confusing for us when you are mixing posts like this. The simplest way is to do what I suggested at Ozgrid.

**Rhonda F** · 08-22-2007, 12:41 AM

Thank you royuk, and everyone else too, for your help.

royuk, I did use the suggestion that you made in ozgrid and miss kf (from ozgrid forum) put it into my invoice and it works great.

I would still like to understand what is going on in the code from my first post here, but I will try to figure it out at a later date.

Thanks!!

Rhonda