tmajor99
asked on
EXCEL - how to change the sequence of specific columns
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;
Sample.xlsx
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;
Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014