Swapping Columns

  • Thread starter Thread starter mePenny
  • Start date Start date
M

mePenny

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
 
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.
 
With a copy of the file, record a Macro and do it manually. That way you
only have to do it right once.
 
Back
Top