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

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" <(E-Mail Removed)> wrote in message
newsB4EA454-B077-4274-9F0A-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> newsB4EA454-B077-4274-9F0A-(E-Mail Removed)...
> > 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
>
>
>

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

Bernie


"Peter Langdon" <(E-Mail Removed)> wrote in message
news:B059B5D4-3F90-4664-9DC8-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> newsB4EA454-B077-4274-9F0A-(E-Mail Removed)...
>> > 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
>>
>>
>>

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."


"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" <(E-Mail Removed)> wrote in message
> newsB4EA454-B077-4274-9F0A-(E-Mail Removed)...
> > 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
>
>
>