+ Reply to Thread
Results 1 to 2 of 2

Sorting multiple grouped rows

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Cary
    MS-Off Ver
    Excel 2003
    Posts
    18

    Sorting multiple grouped rows

    Is it possible to sort multiple grouped rows of data by a cell within each grouping?

    For example...

    Row 10 has a bunch info like a start date in "I10"
    Rows 11 through 28 are grouped and are data for row 10
    (probably best to use the entirerow)
    Row 29 has similar info in structure to row 10 like the start date in "I29"
    Rows 30 through 47 are grouped and represent row 29.

    Can the criteria in rows 10 and 29 be sorted by start date with their corresponding data remaining grouped and beneath each representative row?

    I've been looking into the Range.sort method and the groupings are giving some issues.

  2. #2
    Registered User
    Join Date
    10-15-2012
    Location
    Cary
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Sorting multiple grouped rows

    I've taken a stab at this...

    The same region that was grouped had the first cell merged over the same range so I used the 'mergecells' property instead of grouping. I have a sheet which is named "Gantt" and the code uses the bubble-sort method and a copied sheet to pull data from:

    Please Login or Register  to view this content.
    It's really slow maybe because of how 'mechanical' it is.... sort out the start date, shuffle the start and end points according to the start date, copy the data source, make a copy and delete the original range and then paste in the data according to the sorted startdate array.

    Maybe this gives a better picture of the tool? Is there a better way to accomplish this do you think?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sorting grouped rows ?
    By Kariej1004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2014, 01:32 PM
  2. [SOLVED] Keep grouped rows together while sorting by a value in a cell
    By cbrandonsmith in forum Excel General
    Replies: 2
    Last Post: 04-06-2014, 06:45 PM
  3. Replies: 2
    Last Post: 01-10-2014, 09:30 PM
  4. Converting grouped data in multiple rows and columns to single row
    By learner_123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2012, 05:49 AM
  5. [SOLVED] Sorting Grouped Rows and Formatted Cells
    By sonny.thind in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-29-2012, 01:47 PM
  6. Replies: 0
    Last Post: 07-06-2010, 08:45 PM
  7. [SOLVED] Sorting with multiple rows grouped
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2006, 09:50 AM

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