Macro - Change Event???

[Helen Ryan]

I would like a Macro to copy and paste two columns from one worksheet (separated by two columns) to a second worksheet. BUT if D1=1 on first worksheet I want to copy to cells D3 and E3 on second worksheet, if D1=2 on first week sheet I want to copy to cells F3 and G3 on the second work sheet. (This goes up to D1=12 as in the number of months). A bit of research suggests Change Event? but I am an absolute novice with VBA.

[romperstomper]

It depends - do you want the macro triggered automatically by a change in D1, or do you merely want it to check D1 when you run it?