Results 1 to 14 of 14

Select 1st 2d range, sort, find 2nd, sort, etc

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Fort Rouge, Canada
    MS-Off Ver
    Excel 2010
    Posts
    37

    Select 1st 2d range, sort, find 2nd, sort, etc

    See attached.

    I want to sort each group (there are 3 groups in the sheet) and sort each by F:F, no headers.

    In the sheet 2 I show the desired result

    So in the example sheet, sort D5:l5 by F:F no headers, asc order
    Then sort D9:L11 by F:F no headers, asc order
    Then sort D15:L20 by F:F no headers, asc order

    I have sheets like this with 50 orders and I have to select and sort each.

    How can a macro do that?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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