[KLUG Members] calc

[Adam Williams]

>> > Thank you for your answer. Yes i want "ascending sequence" .how to perform
>> > that?
>> [b1] = [a1] + 1
>> Just fill with the formula
>[disclamer]I don't know calc[disclamer]
>Is there anyway to make this a dynamic formula, one formula that could be
>copy/pasted into every cell.
>[This_1] = [LastOne_1] + 1
>or the other way around
>[an] = [a(n-1)] + 1

Yes and No.  It is dynamic, and cell references are changed dynamically 
when you cut-n-past - unless you specifically declare them to be absolute 
references.

If you cut-n-paste A2 [a1+1] into A3 you'll get [a2+1] in A3.  Thats the 
way it works natively.