Is there any way you can copy from a contiguous range and paste it to
multiple cells or range that are non contiguous i.e. multiple columns of a
different worksheet? Further can you tell excel not to copy data to hidden
columns?