Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rolling document number
I am trying to insert a rolling document in XL 1001, 1002, 1003 etc
any ideas please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
how do i create an automaticly generating number for a document? | Excel Discussion (Misc queries) |