Copy/Pasting with a macro

[tsakta13ole]

Hi.

I attached my spreadsheet.

In the sheet "P_L events up to 1 month" in columns B, C and D (except in row 4 which will remain always constant) I want to paste the results from the sheet "events exp up to 1 month" in columns R, S and T. I want to do that with a macro and the results to be duplicate (B5=B6, C5=C6 and D5=D6).

eg. B5 in "P_L events up to 1 month" to be the same with R9 in "events exp up to 1 month" , B5 the same with S9 in "events exp up to 1 month" and C5 the same with T9 in "events exp up to 1 month". Then, B6 in "P_L events up to 1 month" to be the same with R9 in "events exp up to 1 month" etc. So row 5 to be the same with row 6 for columns B,C and D in "P_L events up to 1 month".
Row 7 and 8 to be the same with R10, S10 and T10 in "events exp up to 1 month" etc.

Hope you understand what I'm trying to do.

Thanks for any help.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[tsakta13ole]

Thanks! This works.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.