Column A should be set aside for "Sequence No":
I like to use the formula (say in cell A10)
=Row() and copy down to A100

It replicats the row number as a seq No;
IF you delete a row - it automatically
renumbers things - SO THIS MIGHT NOT BE A
GOOD IDEA, but then again It might be
something you could use..





"CW" wrote:

I have created a task list that will be shared by several people.
Every time a new task is added I want a unique incremental number to be
assigned to it automatically in the first cell i.e. upon exiting the first
cell in a new row.
I use DMax to do this in Access - is there something similar in Excel?
Many thanks
CW