Hi, I am very new on this forum and I am very begginer in VBA. Actually, I never worked with VBA before. I solved many problems with my macro, but I can't find tips (or they are not clear for me) how to copy data from one sheet and paste to another when specific conditions are met. Now I try to explain more precisely what I need:

Sub CopyData()

If "Sheet1".Range("C10:G12") contains text "Sheet2" and "Sheet1".Range("J4") contains text "Monday" Then copy data from "Sheet1".Range("I20:I25") and paste to "Sheet2".Range("C8:C13") and copy data from "Sheet1".Range("J35")and paste to "Sheet2".Range("E15")

If "Sheet1".Range("C10:G12") contains text "Sheet2" and "Sheet1".Range("J4") contains text "Tuesday" Then copy data from "Sheet1".Range("I20:I25") and paste to "Sheet2".Range("F8:F13") and copy data from "Sheet1".Range("J35").and paste to "Sheet2".Range("H15")
.
.
.
If "Sheet1".Range("C10:G12") contains text "Sheet10" and "Sheet1".Range("J4") contains text "Friday" Then copy data from "Sheet1".Range("I20:I25") and paste to "Sheet10".Range("R8:R13") and copy data from "Sheet1".Range("J35").and paste to "Sheet10".Range("T15")

End Sub

I want this macro to keep pasted data for whole week.

I can't write this in a way that is understood by excel. I tried to do that, but this part of macro did not work or there were problems with parentheses. I hope, that I explained my problem clearly. Thanks for your attention and any replies.

MathewPol