Auto-Generate Number in Sequence

[End_User]

Hello all,

I need your help because I am a bit of a newbie! I have a spreadsheet that has a unique number for each row that gets sorted by due date. When a new record is added, the number for the row has to be the next in sequence. Is there a way to automatically generate the next number that should be used for a new row that is not a duplicate of any of the numbers above it.

Here's an example of what I mean:

1 John Doe email@email.com 1/1/2010
2 Jane Smith email@email.com 5/1/2010
<generate next number = 3> etc...

If it can't be automatically generated, then even if I can pick it from a list would be okay.

The reason I can't just number the rows beneath it and wait for them to be filled in is that this list gets exported based on the number of records in it. If I fill in numbers it exports blank records.

I'm hoping someone here could help me!

 

[LeeLee22]

Hi Lenze
I am also very new at this and have created a job card which when opened would like it to generate the next number. I'd then save it as no....., and then close that main job card. Once I open it again it would automatically go to the next number.
The cell my job numbers are in is F1.

Another stupid question is, if you send me the code, where on earth do i put it and how?

Can anyone help me please, i have SO much to learn!!

 

[Andrew Poulsom]

See:

http://www.mrexcel.com/forum/showthread.php?t=49835&page=2