Dynamic Autofill

[Peter Langdon]

How do I automatically copy a cell into all blank cells beneath it without
having to repeat for each range? I need to autofill all blanks beneath each
entry in order to populate a pivot table.

current desired

TEXT1 TEXT1
TEXT1
TEXT1
TEXT2 TEXT2
TEXT2
TEXT2
TEXT2
TEXT3 TEXT3
TEXT3

 

[Bernie Deitrick]

Peter,

Select the cells, use Edit / Go To... Special Blanks OK, then type =, press the up arrow key
once, then press Ctrl-Enter. Then copy the entire column and pastespecial as values.

HTH,
Bernie
MS Excel MVP

 

[Peter Langdon]

Awesome, thank you. You just saved me hours of tedium.

 

[Bernie Deitrick]

I've saved myself thousands of hours of tedium, so I don't mind sharing. ;-)

Bernie

 

[Colleen Cook]

This was VERY helpful and a lot easier to use than a 'special marco toolbar'
I use to have installed. Also, in excel 2007 go to Home, Find & Select, Go
To... then follow the instructions below " Special Blanks OK, then type =,
press the up arrow key once, then press Ctrl-Enter. Then copy the entire
column and pastespecial as values."