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.

Jase wrote:

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)

--

Dave Peterson