Fill Empty Cells Between Entries...

[DanG]

In column "A" I have text "North Bay" then there will be empty cells for maybe six or seven rows down and then it will have "South Bay". Basically I would like to fill the empty cells with the cell value above until a new cell value is found so it will look like:
North Bay
North Bay
North Bay
North Bay
North Bay
South Bay
South Bay...
I don't know VBA so scap that approach.
I've tried variouse VLookup type functions with no luck.

Thank you

 

[unmarkedhelicopter]

Say you put =A2 in A3, then drag it down as far as you like.
Now you have the value of A2 in ALL of these cells.
Say you want to put "Orange" in cell A6, you now have "Orange" from A6 down.
Now you put "Apple" in A9 you now have apple from A9 down.

 

[DanG]

Thanks for the feedback.

I don't think that will work too well as I am using a webquery and the data gets refreshed (including the formulas if they are in the range).
So I am using a column outside the range to pick this up.

 

[Brianwarnock]

Assuming your 1st cell is A3 copy this to B3, type into B4 =IF(OR(ISBLANK(A4),A4=" "),B3,A4) and then copy down as far as you require, the double test is to allow for empty cells and cells containing a blank, not needed if sure on content


Brian

 

[DanG]

I do not understand how it works (but I will, very soon) but it works great!!

Thank you very much Brian!

 

[Brianwarnock]

Happy to have helped, and I'm sure that you will quickly work out the magic, but if not I'll willingly explain, by now you have probably put =A3 into B3 rather than doing a copy, its amazing how we overlook the simple things.

Brian