When I double click the tab sheet2!C1 to Sheet2!H1 I am able to get them from ascending order (highest to lowest). When I go back to double click sheet2!B1 the column goes in alphabetical order but none of the other columns change with it.
Please see the attached file. There is VB coding.
Bookmarks