Hi
not with formulas alone. For a starting point see:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards
Frank Kabel
Frankfurt, Germany
"beave" schrieb im Newsbeitrag
lkaboutsoftware.com...
I have made a spreadsheet to do service orders for my business. I have the
invoice number in one cell and will be typing the customers name in a
different cell. I want the invoice number to change everytime I type in a
name for the new service order. Can this be done.
Thanks