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]

anjanesh wrote:
> 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)

"anjanesh" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> anjanesh
>
> Freelance Developer
> ------------------------------------------------------------------------
> anjanesh's Profile:
http://www.excelforum.com/member.php...o&userid=27132
> View this thread: http://www.excelforum.com/showthread...hreadid=546806
>

[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...nd.htm#movecol

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"anjanesh" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> anjanesh
>
> Freelance Developer
> ------------------------------------------------------------------------
> anjanesh's Profile: http://www.excelforum.com/member.php...o&userid=27132
> View this thread: http://www.excelforum.com/showthread...hreadid=546806
>