One way

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

--
Regards,

Peo Sjoblom

(No private emails please)


"jeannene" wrote in message
...
I made and invoice excel template and a shipper excel template. Each time
I
open the worksheet to make an invoice, I want the number to change in the
cell on the invoice or shipper. No duplicate numbers. How can I do this?