rolling document number
 

I am trying to insert a rolling document in XL 1001, 1002, 1003 etc
any ideas please

rolling document number
 

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



"Alan" wrote:

I am trying to insert a rolling document in XL 1001, 1002, 1003 etc
any ideas please