I have a program which exports information to an excel spreadsheet in the following format:
Headings:
Name | Code | Size1 | Size2 | Size3
Values:
Prod1 | BE33 | 600 | 500 | 16
Prod3 | BE25 | 18 |400 | 300
Prod2 | BE55 | 250 | 19 | 200
I need to automatically re-arrange all the columns with the Sizes shown with the largest to smallest as follows:
Prod1 | BE33 |600 | 500 | 16
Prod3 | BE25 |400 | 300 | 18
Prod2 | BE55 |250 | 200 | 19
I do not need the rows sorted in any particular order, just the value columns re-arranged for each row.
Is there a way to do this (I am told it could be done but would need a Macro and I know little about macros).
Thanks in advance for any assistance.
Bookmarks