Excel Column Swap

[atomwissenschaft]

Howzit guys,

I've got this problem which I cant find an answer for. I simply need these two selected columns swapped. Not the whole column but only the selection without using copy/paste. Its Office 2007 btw.



Thanks a mil for any help!

[FireFlyComputerSystems]

you could use an underlying formula in the columns. Also, a cell which would act as a switch to swap the two columns depending on its value.

or

Export to a csv file and run a vbscript on it.