Excel Sequential Numbering of cell within worksheet

M

Motorcar Mama

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?
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Assigning Number to Excel Invoice 5
Data tracking and auto sequential numbering 0
template creates invoice - how to create summary worksheet? 13
sequential numbering exceptions 2
populate new "log" worksheet from invoice templates in other sheets 0
Use of Cell Values Instead of Hard Coding 6
auto-numbering for invoices 2
Find a variable cell within a worksheet using a macro. 3

Top