Thread: [Solved] Autofill Automation
View Single Post
 
Old 03-15-2013, 10:39 AM
KsT KsT is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2010
Location: Northeast
Posts: 10
KsT is on a distinguished road
Default

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.
Reply With Quote