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
Bookmarks