How do I automatically pull a new invoice number into an excel te.
 

I want to create an invoice template in Excel, each time I create a new
invoice I will save it as a worksheet/workbook. I need a new unique invoice
number to be automatically generated each time I open the template. I
believe I will need to create some form of database to store invoice numbers
but I don't know where or how to get started with this.

I looked at data - Import External data but this is grayed out?

Can anyone help?

Thanks.

This question is answered about twice a month.
Go to Google; click on Groups; click on Advanced Group Search
In All Words use INVOICE
In Newsgroup box enter (with asterix) *EXCEL*
I got about 7,000 hits

nest wishes
Bernard

"Hube" wrote in message
...
I want to create an invoice template in Excel, each time I create a new
invoice I will save it as a worksheet/workbook. I need a new unique
invoice
number to be automatically generated each time I open the template. I
believe I will need to create some form of database to store invoice
numbers
but I don't know where or how to get started with this.

I looked at data - Import External data but this is grayed out?

Can anyone help?

Thanks.

Thanks,

I'm taking a look now. It seems that the old functionality that Excel use
to suuport (invoicing tools etc) are all gone. I'm working on a mac, I guess
I will end up writing a vba script that will maintain a file that stores
numbers (not my preffered solution as I haven't done that in a while...)

If I knew Access I'd probably give that a go as then I could also store
address information etc...

Thanks,

Hube

"Bernard Liengme" wrote:

This question is answered about twice a month.
Go to Google; click on Groups; click on Advanced Group Search
In All Words use INVOICE
In Newsgroup box enter (with asterix) *EXCEL*
I got about 7,000 hits

nest wishes
Bernard

"Hube" wrote in message
...
I want to create an invoice template in Excel, each time I create a new
invoice I will save it as a worksheet/workbook. I need a new unique
invoice
number to be automatically generated each time I open the template. I
believe I will need to create some form of database to store invoice
numbers
but I don't know where or how to get started with this.

I looked at data - Import External data but this is grayed out?

Can anyone help?

Thanks.

Hube

Check out J.E. McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Gord Dibben Excel MVP

On Tue, 28 Dec 2004 12:59:05 -0800, "Hube"
wrote:

Thanks,

I'm taking a look now. It seems that the old functionality that Excel use
to suuport (invoicing tools etc) are all gone. I'm working on a mac, I guess
I will end up writing a vba script that will maintain a file that stores
numbers (not my preffered solution as I haven't done that in a while...)

If I knew Access I'd probably give that a go as then I could also store
address information etc...

Thanks,

Hube

"Bernard Liengme" wrote:

This question is answered about twice a month.
Go to Google; click on Groups; click on Advanced Group Search
In All Words use INVOICE
In Newsgroup box enter (with asterix) *EXCEL*
I got about 7,000 hits

nest wishes
Bernard

"Hube" wrote in message
...
I want to create an invoice template in Excel, each time I create a new
invoice I will save it as a worksheet/workbook. I need a new unique
invoice
number to be automatically generated each time I open the template. I
believe I will need to create some form of database to store invoice
numbers
but I don't know where or how to get started with this.

I looked at data - Import External data but this is grayed out?

Can anyone help?

Thanks.