PLEASE HELP

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

I am trying create a macro to copy data from a
certain cell or range of cells and then paste into another cell, however if
that cell I am pasting into has data in it I want it to go down 3 cells and
paste it, and so on and so on. I would imagine using the loop function would
work for me but I can't seem to figure it out.

This is what I have but it is just recopying into the same range every time.

Sheets("REAL Move").Range("N23:W36").Copy Destination:=Sheets("REAL
Move").Range("N38").End(xlUp).Offset(16, 0)
 
Check your other post.
I am trying create a macro to copy data from a
certain cell or range of cells and then paste into another cell, however if
that cell I am pasting into has data in it I want it to go down 3 cells and
paste it, and so on and so on. I would imagine using the loop function would
work for me but I can't seem to figure it out.

This is what I have but it is just recopying into the same range every time.

Sheets("REAL Move").Range("N23:W36").Copy Destination:=Sheets("REAL
Move").Range("N38").End(xlUp).Offset(16, 0)
Click to expand...
 
Back
Top