fill

[Guest]

what i want to do is to fill cells automatically everytime there is a change
in the name. can anyone help?
for example, cell A1 may say Apple then A1230 may say Orange and then A13560
may say Lemon. I want to be able to fill the blanks cells between Apple and
Orange with Apple, cells between Orange and Lemon with Orange

 

[Guest]

Hi
Select the column / range. Then Edit / Go to / Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values on the range.
Hope this helps.

 

[Guest]

thank you very much.
you are a genius.

Hi
Select the column / range. Then Edit / Go to / Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values on the range.
Hope this helps.

 

[Guest]

Pleased to help and thanks for the feedback!