If the last row of all three columns is the same, then this common little snippet does just fine. (or if B has the greater last row)


Sub HMMMM()

Sheets("Sheet7").Range("B2:D10").Copy Sheets("Sheet8").Range("B" & Rows.Count).End(xlUp)(2)

End Sub


I want that capability along with should column D have a last row greater than B or C then paste to column B using columns D's last row.

So the code can past "uneven columns lenghts" always to B and to the last row of any, should they not be the same.

Thanks,
Howard