I have 15 different companies in columns G thru U that I would like to sort based upon the total quarterly sales amounts found in row 53. I want the the company with the lowest sales to appear in column G ascending to the company with the highest sales in column U. The name of each company is located in line one of each column.

The macro that was originally created to sort this range of columns has become obsolete and I am looking for some help on this. Thank you!