I frequently need to create invoices in Excel using a template I downloaded
from Microsoft template library. I would like to number these invoices
automatically. I.E., the first invoice is numbered 08-001, the next 08-002,
etc. The number is located in the same cell in each new workbook. The
invoices could be contained as worksheets in a workbook.

Any suggestions on how to accomplish this?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Motorcar Mama" wrote in message
...
|I frequently need to create invoices in Excel using a template I downloaded
| from Microsoft template library. I would like to number these invoices
| automatically. I.E., the first invoice is numbered 08-001, the next 08-002,
| etc. The number is located in the same cell in each new workbook. The
| invoices could be contained as worksheets in a workbook.
|
| Any suggestions on how to accomplish this?

Have you started with
http://groups.google.co.uk/groups/se...bering+invoice ?
--
David Biddulph

"Motorcar Mama" wrote in message
...
I frequently need to create invoices in Excel using a template I downloaded
from Microsoft template library. I would like to number these invoices
automatically. I.E., the first invoice is numbered 08-001, the next
08-002,
etc. The number is located in the same cell in each new workbook. The
invoices could be contained as worksheets in a workbook.

Any suggestions on how to accomplish this?