I have a column with with numbered data in it. I need a macro to read column
A if it sees data it takes it and enters it in the blank cells below it,
until it comes across another cell in the column with data and then it starts
entering that in the empty cells below it. It needs to stop if there is no
data in column B associated with that row.

Any help would be great.

Thanks