How do I create a unique number for invoicing in excel?
 

I am trying to create invoices n Excel that will insert a unique reference
number each time thetemplate is opened.

I am not sure which function will work for this application, or whether I
need to create something in visual basic.

Has anyone got any suggetions?

Thanks

David

How do I create a unique number for invoicing in excel?
 

You may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

Denni123 wrote:

I am trying to create invoices n Excel that will insert a unique reference
number each time thetemplate is opened.

I am not sure which function will work for this application, or whether I
need to create something in visual basic.

Has anyone got any suggetions?

Thanks

David

--

Dave Peterson

How do I create a unique number for invoicing in excel?
 

"Dave Peterson" wrote:

You may want to look at the way J.E. McGimpsey approached it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

Denni123 wrote:

I am trying to create invoices n Excel that will insert a unique reference
number each time thetemplate is opened.

I am not sure which function will work for this application, or whether I
need to create something in visual basic.

Has anyone got any suggetions?

Thanks

David

--

Dave Peterson

Thanks. I'll have a look.