The Code below copies from a range, looks for the right number of consecutive blank cells in the desitnation range and pastes cells. (need to retain cell/number formats)
I would like to achieve somehting similar, but the blank cells don't have to be consecutive, there just need to be enough...