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?