In A1 enter:

=ROW() and copy down

this make a column of numbers. If you delete a row somewhere in the middle,
the column will automatically re-number.
--
Gary''s Student - gsnu200782


"JICDB" wrote:

I have a numbered waiting list with 500+ members. When someone in the middle
decides to cancel, I would like them to be renumbered automatically. Is this
possible? It isn't diffiecult to clear the numbered column and then use
autofill, but I want something more user friendly for my co-workers.