Maybe you could record a macro when you copy|paste each column.

Then when you need to do it again, you can just rerun this macro.

Manoj wrote:

I have 2 spreadsheets with data. NOw i want to copy alternate columns from
the first sheet (A, C, E, G and so on) and paste in the second in the
alternate columns (A, C, E, G and so on). The data in column B, D, F, H and
so on should not be disturbed in the second sheet.

Is this possible at one go. Not individual copy / pasting of columns.
There are many such sheets where data has to be copied / pasted.

Thanks in advance

--

Dave Peterson