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.