Hi all,

I'm not entirely sure if this is possible but....

Is it possible to programme excel to copy a range of cells into another range based on the value of a cell i.e.

If A1 = 1 copy cells G3:G13 into A3:A13
If A1 = 2 copy cells K3:K13 into A3:A13

and so on....

Thanks,

joe