As I go through the data validation, I wish to paste column C:D into A:B on sheet "1".

Next data I wish to do the same, but this time sheet "2"


Sub Range_Copy_Examples()

Worksheets("1").Columns("A:B").Value = Worksheets("Model").Columns("C:D").Value

End Sub


However, I have to iterate Worksheet "1" and run macro for 1,2,3,4,5,./


Something like?

Worksheets((Model(A1)).Columns("A:B").Value = Worksheets("Model").Columns("C:D").Value