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

Bernie


"Peter Langdon" wrote in message
...
Awesome, thank you. You just saved me hours of tedium.
--
pl


"Bernie Deitrick" wrote:

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" wrote in message
...
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
--
pl