Auto numbering in Excel

[Matt]

I'm trying to figure out a way to auto number. I have a
list of 2500 line items and when I take one out I need the
numbers in the column to the left to re-number themselves.
These line items have 2 to 15 rows between them.

For example:
Row 4 in a worksheet- Column A has the number 1
designating the first product in the worksheet with
columns b through g and rows 4 through 10 containing
information about that product. Row 11, column A would
then have a number 2 showing the second product with
columns b through g and rows 12 through 15 containing
information about that product. I trying to re-number the
column A numbers after a product (one or many rows) have
been removed.

Any help would be greatly appreciated.

Thank you.

[Tim C]

One way:

Select A4
Ctrl-Space
Edit/Goto/Special/Constants/OK
You should now have all of your numbers selected, with A4 as the active
cell.

Enter the following formula, using Ctrl-Enter
=MAX($A$3:A3)+1

Ctrl-Enter will fill the formula into all selected cells.

That should work.

Tim C

"Matt" <Ore...@optonline.net> wrote in message
news:00ec01c34710$d65af580$a501...@phx.gbl...