Fill Empty Cells Between Entries... (1 Viewer)

DanG

Registered User.
Local time
, 17:03
Joined
Nov 4, 2004
Messages
477
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

Registered User.
Local time
Today, 01:03
Joined
Apr 23, 2007
Messages
177
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

Registered User.
Local time
, 17:03
Joined
Nov 4, 2004
Messages
477
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

Retired
Local time
Today, 01:03
Joined
Jun 2, 2003
Messages
12,701
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

Registered User.
Local time
, 17:03
Joined
Nov 4, 2004
Messages
477
I do not understand how it works (but I will, very soon) but it works great!!

Thank you very much Brian!
 

Brianwarnock

Retired
Local time
Today, 01:03
Joined
Jun 2, 2003
Messages
12,701
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
 

Users who are viewing this thread

Top Bottom