I have a list of names with a random # empty cells in between - and there's
215 of them (see below). All I want to do is copy A until B begins, then B
until C begins, etc. When I record the macro, well, it doesn't work - it
takes the last name I landed on, and pastes it in all of the cells I already
populated . I could have sworn i've done this before, but for the life of
me, can't get it to work again. It will save me about 3 hours of my life if
I can get it to work. Help, please?

COLUMN A
A
blank cell
blank cell
B
blank cell
blank cell
blank cell
C
blank cell
D
blank cell
blank cell
blank cell
blank cell
E - through whatever would take me to a total of 215.