+ Reply to Thread
Results 1 to 2 of 2

Sorting A Range based upon one row

  1. #1
    Registered User
    Join Date
    06-15-2006
    Posts
    8

    Sorting A Range based upon one row

    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!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    You are able to sort by row manually if you set the appropriate option in SORT.
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1