Is it possible to have EXCEL to change the sequence order of attributes automatically. Use Case - user has 100 columns in spreadsheet and a certain section of these needs to be reordered. Let's say a spreadsheet has the column headers listed below.
ID Name Date Description Size Length Height
How can EXCEL automatically re-arrange the Size, Length and Height so it looks like this:
ID Name Date Description Height Size Length
This work cannot be done manually because in reality there are about 25 column headers that need to be re-arranged daily. I was hoping someone can point me to a solution that allow the users to define the columns that need to re-arranged and define the order they need to be displayed in without impacting the other columns in the file. I attached another example;