update numeric labels after insert

[davegb]

I have a spreadsheet with a list of bills before the State Legislature.
I'd like to be able to insert a new bill into the list and have the
numeric labels, 1,2,3,4... automatically increase by 1 from the
inserted row down rather than have to re-autofill all of them. I can't
imagine that someone hasn't already done this. Anyone have any ideas?
TIA

 

[RagDyer]

In your numbers column, try this:

=ROW()
And drag down to copy as needed (the first time).

From then on, all you'll need to fill will be the actually inserted rows.

If you're not starting at Row1, revise the formula to get the starting
number, for example:

=ROW()-2

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a spreadsheet with a list of bills before the State Legislature.
I'd like to be able to insert a new bill into the list and have the
numeric labels, 1,2,3,4... automatically increase by 1 from the
inserted row down rather than have to re-autofill all of them. I can't
imagine that someone hasn't already done this. Anyone have any ideas?
TIA

 

[Bob Phillips]

Doesn't the row heading at the left achieve this?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[davegb]

Excellent! Thanks Rag!

 

[davegb]

Excellent! Thanks RD!