lhardee
12-29-2008, 10:11 AM
Hello,
I am trying to write a macro that will rearrange columns in a certain order. Each column's 1st cell has a name as follows. Column A = Eqp Additional Info Column B = Equipment Name Column C = Time Up Column D = Alarm Type.
I would like the columns to be arranged as Column A = Alarm Type Column B = Time Up Column C = Equipment Name Column D = Eqp Additional Info.
I know I can just manually move columns...but each user's sheet could have thse columns in a different order as shown above. The only common point is that the column names are the same. I was trying to focus on that using maybe an array or some way to look for those column names and then rearrange.
Thanks
lhardee
I am trying to write a macro that will rearrange columns in a certain order. Each column's 1st cell has a name as follows. Column A = Eqp Additional Info Column B = Equipment Name Column C = Time Up Column D = Alarm Type.
I would like the columns to be arranged as Column A = Alarm Type Column B = Time Up Column C = Equipment Name Column D = Eqp Additional Info.
I know I can just manually move columns...but each user's sheet could have thse columns in a different order as shown above. The only common point is that the column names are the same. I was trying to focus on that using maybe an array or some way to look for those column names and then rearrange.
Thanks
lhardee