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

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

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

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