i use a simple formula to add sequential numbering in a worksheet such as
=A1+1 and i copy the formula for all cells as needed. The problem is when i
add or delete rows i have to copy and paste the formula. Is there a way to
have a formula continue the sequential numbering without this?
--
Scott Hemphill

Paste this in the second cell and copy down
=(ROW()-1)+1
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Scott Hemphill" wrote:

i use a simple formula to add sequential numbering in a worksheet such as
=A1+1 and i copy the formula for all cells as needed. The problem is when i
add or delete rows i have to copy and paste the formula. Is there a way to
have a formula continue the sequential numbering without this?
--
Scott Hemphill

This would work if every cell was a number but i need the numbering to start
in different cells and skip other cells? Any more information please?
--
Scott Hemphill


"John Bundy" wrote:

Paste this in the second cell and copy down
=(ROW()-1)+1
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Scott Hemphill" wrote:

i use a simple formula to add sequential numbering in a worksheet such as
=A1+1 and i copy the formula for all cells as needed. The problem is when i
add or delete rows i have to copy and paste the formula. Is there a way to
have a formula continue the sequential numbering without this?
--
Scott Hemphill