The below listed code
sheet1 macro copies from one sheet and then paste exact on sheet2 by column
How can I force the paste action to be in col A? each paste in col A

Sub aaaaa(
mysf = "xxx
myst = "yyyyy
For myrow = 11 To 15 Step
For mycol = 3 To 33 Step
myval = Sheets(mysf).Range("a1").Offset(myrow - 1, mycol - 1).Valu
If myval = "yes" The
Sheets(myst).Range("a1").Offset(myrow - 9, mycol - 3).Value = Sheets(mysf).Range("a1").Offset(myrow - 1, mycol - 1).Valu
End I
Next myco
Next myro
End Su

Thanks
Rozb