With a copy of the file, record a Macro and do it manually. That way you
only have to do it right once.

mePenny wrote:

Eduardo,

That's just it, i dont' want to do this manually. My luck, in the past, has
shown that some how some way, I do something wrong.

"Eduardo" wrote:


Hi Penny,
to swap columns just select lets's say column C, right click in the mouse,
cut, select
no column B, right click paste

If this helped please click yes
"mePenny" wrote:


I have a list of vehicles with license plate and key number, all having there
own column. Is there a formula where B & C, F & G, J & K will swap places?
(would like to see key, plate, vehicle, assigned, ect..)

B = Plate #
C = Key #
D = Vehicle
E = Where vehicle is assigned
F = Plate #
G = Key #
H = Vehicle
I = Where vehicle is assigned
J = Plate #
K = Key #
L = Vehicle
M = Where vehicle is assigned

Thank you in advance for the help.
Penny