Insert a <<new column to the left of the Name Column
and enter (same row as first record name which is in say d4) into c4
=subtotal(3,$D$4:D4) and Copy down to D804. This should furnish
sequential numbering whether your table is filtered or not, and whether
rows are added or deleted.
HTH
Jim May

"JeffMelton" wrote in message
ups.com...
If you run an autofilter in column A and the drop down shows:
Adam
Bob
Dave
George
Mark
Steven
etc

Is there a way to reference Adam as 1 or something? Bob would be 2 Dave
would be 3 etc.

What I'm thinking is something like autofilter A and then criteria
would be Adam so I can copy and paste to a new sheet. Right now I have
maybe 800 different names and I'm trying to figure out an easier way to
move each individual entry and the number will only go up.