Copy to next available column in a sheet

[Flower R]

Hi,
In Sheet1, columns A,B,C,D,E, and F have data. with the help of a micro, I wish
to copy(paste value) the Column F (range F2:F130) to Column G (G2:G130), and then to
Column H, I, J,K, L. So If column G is filled, next copying may be in H and
so on.:
Range, F2:F132
selection. copy
paste.value
destination range H2:H132
and so on.
Thanks.

[tigeravatar]

Flower,

Something like this?

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Flower R]

Thanks for reply. But the destination column is G, whereas with this
micro the data goes to Column B. The destination Column is G and then
it will be H and so on.

[Flower R]

Thanks. have changed setrangedest from cells 1 to 2. and it is working.
thanks a lot.