Hi,

From what I've been learning I would have thought this was a simple Macro to
write. However I'm having a lot of trouble!!

Basically I want A macro that will check the value in cell A1 and if the
value equals 1 then it should give one output. but if it equals 2 it should
give another output etc for 4 or five outputs. I'm guessing that I need to
use the IF, then, else statement but can't seem to figure it out.

If someone could show me the code which does exactly this

If A1 = 1 then copy cell C1 and paste into D1 but if A1 = 2 then copy cell
C2 and paste into D2 but if A1 = 3 then copy cell C3 and paste into D4.

Then I can work from there with what I want it too do.

Thanks for your help!
Carl