Dynamic Autofill

  • Thread starter Thread starter Peter Langdon
  • Start date Start date
P

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
 
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
 
I've saved myself thousands of hours of tedium, so I don't mind sharing. ;-)

Bernie
 
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."
 
Back
Top