Hi Metric

If you start in row 1 you can use thsi formula and copy it down

=ROW()

If you start in row 6 then you can use this

=ROW()-5


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Metric" wrote in message ...
My company has a service log (Excel Spreadsheet) they started 3 years
ago...each entry was given a manual number (column A)...over time people have
just generated that number manually...sometimes they can't count and the next
number is 1 off. I'm trying to determine if there is an easier way to auto
generate the next number in the list. For example we are at 7000; I want the
next row down to generate 7001. How can I do this???