I want to fill in all the blank cells in the first column with the text value that is in the begining cell until the next populated cell, after which the value from the next populated cell will be copied down, and so on. In other words a table like:

A B
George Red
Blue
White
James Green
Brown

Would look like this, after the macro is activiated:

A B
George Red
George Blue
George White
James Green
James Brown

Thanks for any help.