Copy every nth cell on 1 worksheet and paste to every nth cell on another

[homeexcel]

Good morning!

I am trying to do the following:

1. Copy the data in every 3rd cell from worksheet A starting at D6 and running to D 360
2. Paste that data to every third cell on Worksheet B starting at E30 and running to the end of the data string

Any thoughts?

[Sunny18pc]

Hi, If you are looking for a static (one time), then in Worksheet B you can use formula refer by address if

Paste in E30

Please Login or Register  to view this content.

And continue to change the value of D6 by multiple of 3

*Mark the thread as Solved if your concern is solved.