copy&paste every nth cell to another sheet

  • Hi,

    Really need some help with the following task please.

    I need a macro to copy and paste every 2nd cell in specific columns (they differ) to another sheet but in consecutive rows. I need for instance to copy and paste everything that has a value, starting from cell G9 and continuing with G11, G13... and start copying into another sheet from B3, B4, B5.... I also need in the same macro to copy and paste the cells from G10, G12, G14... into the other sheet into DX3, DX4, DX5..... I would usually have between 5 and 25 cells to copy.

    If anyone could explain how to do this it would be much appreciated!

  • Try this (untested). Adjust sheet names to suit.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!