autofill Rows Excel from given input values

[ericwill43]

Is there a way to fill rows in excel with given input values? for tens of thousand rows

across several different files given over 400 input values:
So I need to fill cell A2 with Ander all the way down to next team take that team name fill it

all the way down to next team etc, etc, etc
Example: (The dates are in col B team names in ColA)
Starting Data Desired Result
ColA ColB ColA ColB
Example:
Starting Data Desired Result
ColA ColB ColA ColB
Ander 11/1/2007 Ander 11/1/2007
11/5/2207 Ander 11/5/2207
11/16/2007 Ander 11/16/2007
12/4/2007 Ander 12/4/2007
12/8/2007 Ander 12/8/2007
12/27/2007 Ander 12/27/2007
1/7/2008 Ander 1/7/2008
1/29/2008 Ander 1/29/2008
2/29/2008 Ander 2/29/2008
3/1/2008 Ander 3/1/2008
Barry 11/7/2007 Barry 11/7/2007
11/14/2007 Barry 11/14/2007
11/16/2007 Barry 11/16/2007
12/4/2007 Barry 12/4/2007
12/8/2007 Barry 12/8/2007
12/27/2007 Barry 12/27/2007
1/7/2008 Barry 1/7/2008
1/29/2008 Barry 1/29/2008
2/29/2008 Barry 2/29/2008
3/1/2008 Barry 3/1/2008
3/6/2008 Barry 3/6/2008
Chico 11/5/2007 Chico 11/5/2007
11/14/2007 Chico 11/14/2007
11/16/2007 Chico 11/16/2007
12/4/2007 Chico 12/4/2007
12/8/2007 Chico 12/8/2007
12/27/2007 Chico 12/27/2007
1/7/2008 Chico 1/7/2008
1/29/2008 Chico 1/29/2008
2/29/2008 Chico 2/29/2008
3/1/2008 Chico 3/1/2008
3/4/2008 Chico 3/4/2008
Delan 11/5/2007 Delan 11/5/2007
11/14/2007 Delan 11/14/2007
11/16/2007 Delan 11/16/2007
12/6/2007 Delan 12/6/2007
12/8/2007 Delan 12/8/2007
12/21/2007 Delan 12/21/2007
1/7/2008 Delan 1/7/2008
1/24/2008 Delan 1/24/2008
2/29/2008 Delan 2/29/2008
3/1/2008 Delan 3/1/2008
3/5/2008 Delan 3/5/2008




I would like to autofill all empty rows in column a starting from the top all the way to the

end of list with the next teams name. no team more than once. Teams Season starts in Nov or

Dec and runs thru Feb to March. There may be a better way than autofill im not sure?

 

[russellrichter]

Eric,

Here is my solution:

1. Select the first empty cell under Ander (in your example).
2. Press the = key to start entering a formula.
3. Hit the Up Arrow key to select the cell above.
4. Hit Ctrl-Enter to enter the formula.
5. Hit Ctrl-C to copy the cell.
6. Hit Ctrl-* to select the current region.
7. Hit Ctrl-G, click Special, check Blanks, and hit OK. This selects all blank cells in the selected region, not just the ones in the current column. Since you listed only 2 columns in your example and the 2nd column has no blanks, this will work.
8. Hit Enter to paste the formula to all the blank cells.

If this is something you do often, you might record it as a macro and assign it to a Ctrl key.

HTH
Russ