Hi Holly

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Holly" wrote in message ...
I'm trying to create a worksheet that, when opened, automatically changes the
P.O. # to the next number.
Any ideas?