consecutive numbers

[amyenoch]

I'm creating a purchase order form in Excel. I would like the purchas
order number (in, say, cell A7) to automatically change to the nex
consecutive number each time I open the file. Is there a way to d
that

 

[amyenoch]

Thanks, Anil. I'll hang on to this; I also have another idea tha
mimics another project I was doing before that I think will work, too

 

[Tom Ogilvy]

Won't that change each time you open the workbook. so when you first enter
the purchase order, it will be number 1. Then the next time you look at or
edit it it will be number 2 and the next time number 3.

 

[Tom Ogilvy]

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