+ Reply to Thread
Results 1 to 5 of 5

Sorting within boxes yet again

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,990

    Sorting within boxes yet again

    This is the third post I've had on this subject, going back years without a true resolution. The last post is here: http://www.excelforum.com/showthread...27#post2553327
    The process is I'm creating a pivot from a lot of data. Then the pivot turns into a report. The trick to it is for each deptID, we want the supervisors in order by name. The finished report has to be in the format shown (but with the columns expanded, of course). The overall issue is shown in the pictures. Note that Koli (the names are fake) is no longer bordered by the two total lines:Attachment 409485

    A related issue may be that the macro I'm still trying to use (below) doesn't take the Progam Code (PAC) into account. The range to sort is all fields within each DeptID, sorted in Supervisor order,and PAC needs to stay with the employess (a DeptID might have more than one PAC, and a Supervisor MIGHT be a supervisor of more than one PAC). Any help would be greatly appreciated.
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Sorting within boxes yet again

    Maybe it is me, but this is the second post I have tried to open an 'Attachment' and I get an invalid link error. Grrr.
    In looking at your image, it seems to have a problem when there is only one item in a 'group'. Try changing this line of code:
    Please Login or Register  to view this content.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,990

    Re: Sorting within boxes yet again

    For someone who can't see the attachment you see pretty well. The update seemed to fix the issue with the single lines. I'll be checking it against different runs today, so probably won't post again until late today or tomorrow, but in anticipation of a successful solution, THANK YOU!

  4. #4
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Sorting within boxes yet again

    Glad it worked. You can pay me back with a lunch at Franklins...

  5. #5
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,990

    Re: Sorting within boxes yet again

    I didn't spot any issues, but have settled on an alternative method for creating my table, using Subtotals instead of a Pivot, so I won't be using the Resort macro in the foreseeable future. But thanks to all the people who have helped me with it over the years, and most lately Pauleyb, I'll keep this one in my toolbox; no telling when it will come in handy. Thanks so much!

    Pauleyb, I'd love to take you to Franklins, except as a vegan I don't find much use for barbecue places, unless it's one that makes a good vegan pulled pork (see http://www.onegreenplanet.org/vegan-...bbq-jackfruit/)

+ 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 with check boxes - cells appear linked
    By SMcuthbert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2013, 02:09 PM
  2. [SOLVED] Check Boxes and Sorting/Filtering
    By HNoel33 in forum Excel General
    Replies: 2
    Last Post: 07-30-2013, 10:21 AM
  3. [SOLVED] Can check boxes be included in sorting, using VBA
    By grahamc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-26-2012, 04:53 PM
  4. Sorting within Boxes (revisited)
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2011, 10:03 AM
  5. Sorting within boxes
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-17-2011, 10:06 AM
  6. Sorting with drop boxes
    By mewingkitty in forum Excel General
    Replies: 2
    Last Post: 10-23-2008, 06:40 PM
  7. Sorting Data in Multiple Combo Boxes
    By ElsieC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2008, 10:26 AM
  8. macro sorting drop down boxes
    By hoshino in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2007, 05:58 AM

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