Debra Dalgleish shares some techniques he
http://www.contextures.com/xlDataEntry02.html
and a video he
http://www.contextures.com/xlVideos01.html#FillBlanks

bean wrote:

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.

--

Dave Peterson