Indexing invoice number

G

gvd1997

I am not an Excel expert by no means; however, I am building a template
for my quotations department to use. Is there a simple way to make the
cell that will contain the quote number automatically assign the next
sequential number? As an example, if a user used quote# 1000 on a
quote, I would like the next user to be assigned quote# 1001.

I aaume I will have to build a numbers listing.

Thank you for your input.
 
G

Gord Dibben

You will need to employ a little VBA.

See John McGimpsey's site for code.

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


Gord Dibben MS Excel MVP

I am not an Excel expert by no means; however, I am building a template
for my quotations department to use. Is there a simple way to make the
cell that will contain the quote number automatically assign the next
sequential number? As an example, if a user used quote# 1000 on a
quote, I would like the next user to be assigned quote# 1001.

I aaume I will have to build a numbers listing.

Thank you for your input.
Click to expand...

Gord Dibben MS Excel MVP
 
Top