Automatically Reorder 77 Columns based on row 1 contents

[slam]

We have a system with an excel export, but the columns are not in the order we need, nor are they even in the same order each time we perform this export.

Is it possible to redefine the columns in Excel with some VBA? I would want this done based on the contents of A1 through CY1. These values are consistent and unique.

If anyone can point me in the right direction, I would greatly appreciate it!

 

[mole999]

first off i would look at macro recorder, record your actions you use to fix the file, then it could be refined for regular use

 

[slam]

first off i would look at macro recorder, record your actions you use to fix the file, then it could be refined for regular use

Since the columns are always in a different order when exported, I don't think I could use a macro recorder. I think I'd have to define the order of the columns in the VBA, based on the contents of row 1.

 

[mole999]

do they have headers

 

[slam]

Yeah, row 1 is the headers, and all header values are unique.

 

[mole999]

so potentially the header may be the key to getting it to sort