Excel Macro to Repeat Paste Between Sheets

[bluemanuk1]

Hi There,

Hope someone can help.

I have 2 sheets of date. Sheet 1 contains a temple range A3:T162. This set of data is repeated x number of times. Sheet 2 contains a range of data A1:A3 repeated x number of rows. The data is different on each row. So if I have 10 rows of data in Sheet 2 , there will be ready in Sheet 1 10 sets of dats, as in range A3:T162.

I would like the following action:
the contents of Sheet 2 Row 1 to be pasted into Sheet 1 cell A3,B3,C3
then contents of Sheet 2 Row 2 pasted into A163,B163,C163,
then contents of Sheet 2 Row 3 pasted into A323,B323,C323,

So basically each consecutive row on Sheet of column A,B,C is pasted back onto Sheet 1, 160 rows below until all contents of Sheet 2 has been exhausted.

I have attached an excel sheet with the relevant data.

Please let me know if you require any further information.

[sktneer]

Try this code to see if this works as per your requirement.

Please Login or Register  to view this content.

[Joakim N]

Try this code:

[bluemanuk1]

This works perfectly, thank you so much.

[bluemanuk1]

Thank you for your reply. I have tried it but it says Macros are disabled even though they aren't. Thank you anyway, the first reply works fine.

[sktneer]

Glad to help you. Thanks for the feedback.
Since you are new to forum so just to tell you that if that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

[bluemanuk1]

All done, i am sure I have left feedback ratings too, please let me know if I have missed anything.