Parkie1981 re:Autofill Automation - If you are only trying to fill the name down for the 5 performance areas, try this.
1)Add a new column at A, numerically autofill all of the rows in column A (relevant to your data).
2)Sort by column B (Name# column)
3)at the first row with a blank in the name# column type = and point to the cell above, copy this formula to all the other blank cells in column B.
4)Resort by column A. The name# column now appears like your Finish example.


5)Copy column B, Paste Special, Values (overwriting the column).
6)Delete column A (sorting column) and you are done.
I do this all the time with large amounts of data.