Swapping columns

[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

 

[Puppet_Sock]

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

 

[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)

 

[David McRitchie]

You could record a macro, but you might just simply use the
Shift key and the mouse you will have to move columns 4 times though.
http://www.mvps.org/dmcritchie/excel/fillhnd.htm#movecol