Swapping columns

A

anjanesh

I need to swap many columns so that col D is at col A, col C is at col
G, etc etc - without any column being deleted.

Is there a swap function somwhere ?

Thanks
 
P

Puppet_Sock

anjanesh said:
I need to swap many columns so that col D is at col A, col C is at col
G, etc etc - without any column being deleted.

Is there a swap function somwhere ?

You could copy the source sheet to a temp sheet. Then delete the
entries on the dest sheet (to be sure you don't leave any you don't
want in locations you don't want). Then copy the data you want
from the temp sheet to the original sheet. Then delete the temp sheet.
Socks
 
B

Bob Phillips

Try turning the macro recorder on, then do it in Excel. This will give you
the code.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top