Hi All,

I have a need to create a Macro that copies alternating cells until end of data.

In my scenario I will end up with 2 sheets, each containing x number of rows (with the first row being a header row).

Row 1 in Sheet 1 has a relation to Row 1 in Sheet 2.
Row 2 in Sheet 1 has a relation to Row 2 in Sheet 2.
Row 3 in Sheet 1 has a relation to Row 3 in Sheet 2.
Row 4 in Sheet 1 has a relation to Row 4 in Sheet 2.

and so on...

What I am trying to achieve here is a Macro that copies:

Sheet 1 Cell AA2 -> Sheet3 Cell A2
Sheet 2 Cell P2 -> Sheet3 Cell A3

...Sheet 1 Cell AA3 -> Sheet3 Cell A4
...Sheet 2 Cell P3 -> Sheet3 Cell A5
...Sheet 1 Cell AA4 -> Sheet3 Cell A6
...Sheet 2 Cell P4 -> Sheet3 Cell A7
...Sheet 1 Cell AA5 -> Sheet3 Cell A8
...Sheet 2 Cell P5 -> Sheet3 Cell A9

etc;

and then keeps copying and pasting in that order and stops when Sheet 2 Column P = "" (blank).

I would be most grateful for any assistance that can be rendered.