macro to copy and paste range of cells to variable cell reference

[sgkessel]

Hello... I'm new, need help... and you masters of excel can probably solve this faster than I can compose this post

I need a macro that copies a range of cells... easy
then pastes it... in a column... at the first instance of a 3rd consecutive empty cell.. ie starting from the top of column B and searching til it finds the green cell (b31 in this case) and pasting there... so no matter how many times I press it, it keeps going down to the new set of empty cells... thanks in advance!

 

[sgkessel]

tweedle... thank you... I'm actually going to work with the previous code as it works perfect assuming I have a full column in B and for now that is all I need... thanks for your help!