automatically generated numbers

[carl ledlow]

Is it possible to have fields in a particular column
automatically generate sequential numbers when the enter
key is pressed

 

[Frank Kabel]

Hi Carl
not sure I understood you. Could you give an example. Especially: what
do you mean with 'when the enter key is pressed')

 

[Carl Ledlow]

Original Message
Hi Carl
not sure I understood you. Could you give an example.
Especially: what
do you mean with 'when the enter key is pressed')


Regards
Frank Kabel
Frankfurt, Germany


carl ledlow wrote:
Is it possible to have fields in a particular column
automatically generate sequential numbers when the enter
key is pressed
Hi Frank

Lets Say for example that I have a List of items to enter
into a worksheet with, say, 5 columns. What I want happen
is this, at the end of the 5th column I would press the
(entre) button and have the next available number in the
list automatically generated by the system as soon as the
field is highlighted

 

[Frank Kabel]

Hi Carl
maybe the following helps you (creates a sequence number in column A
after you have entered something in column F of the previous row):
in A1 enter
1
in A2 enter
=IF(F1<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy down