Generate Auto Order Number
 

I have an Excel template that is set up for work orders. Each order has a
unique order number (one number higher than the last). I would like to
create a macro that will assign the order number based on the last saved
order number. I do not want an order number generated if the last order was
not saved. Any suggestions?

Generate Auto Order Number
 

Hi Cher,
You might try this link:

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

--
Ken Hudson


"cher" wrote:

I have an Excel template that is set up for work orders. Each order has a
unique order number (one number higher than the last). I would like to
create a macro that will assign the order number based on the last saved
order number. I do not want an order number generated if the last order was
not saved. Any suggestions?