Moving information to next empty cell

Do you want the code to ask which will be the first column to paste into? Since Column P is not the next empty cell, how would the code know where to start pasting.

it would be easier to just paste on the next empty cell rigth? It is ok to paste on the next empty cell as the first column.

Thanks for your time

Next empty column on row 5. You can adjust
Range("G6:L6").Copy
into

Range("G6:L" & Range("G" & Rows.Count).End(xlUp).Row).Copy
if you want to copy non empty rows

Please Login or Register  to view this content.

Select a cell in Column G only(G6 or G7 or G8 or whatever). Not the whole range (G6:L6)

Please Login or Register  to view this content.

Hopefully this will help

Please Login or Register  to view this content.

Is it possible to start on the next empty cell instead of making an input of the column?

here is an update

Please Login or Register  to view this content.

Select a cell in Column G and run code as many times as you wish.

Please Login or Register  to view this content.

Or for values only

Please Login or Register  to view this content.

Thanks all for the information and backup, this is what I was looking for.

Best regards!

Thanks for this, this is exactly what I wanted, it is now working.

Best regards,