Dear Alan: I have a small solution for you if it works and you need it this
way.
Let's assume that you us A column for autonumbrer, B Column for Name and C
Colomn is for position or whatever as your last entry column, use the
following formula and copy in cell A2:
=IF(AND(A2="",C2=""),"",IF(C2="","",A2+1))
You can lock column A by protecting your sheet to not select lock cells then
if you want. I hope this would help you.
Best,
Daoud Fakhry
