Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2010
    Location
    Oregon
    Posts
    61
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Grouping, but not summarizing

    I have a table of active service requests, each number unique and each assigned to a person. I don't need to summarize anything, but rather I need to GROUP eight columns (from the 33 columns in the master table) by the assignee. For example, PersonA might be assigned 15 SRs. I need a worksheet where, using the master data (on another worksheet), lets me select a PersonA and then list all 15 SRs along with the eight columns in which I'm interested.

    Neither grouping nor pivoting seem conducive to this. I think I can properly make a combo box where I can select a person, but don't know how to show/retrieve their respective rows and columns. Once I am able to do this, I then need to add conditional formatting and other logic, but first things first. Any help in steering me in the right direction much appreciated.
    Attached Images Attached Images

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Reid,

    Give Advanced Filtering a look I think it is exactly what you need using the option to copy to another worksheet for the results. Post back if you need help with the specifics. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Star Lounger
    Join Date
    Jan 2010
    Location
    Oregon
    Posts
    61
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I was able to copy to another worksheet, but unable to pick the columns I want copied. I only want eight of the 33 columns, and the eight are not contiguous.

  4. #4
    Star Lounger
    Join Date
    Jan 2010
    Location
    Oregon
    Posts
    61
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Resolution: After monkeying around more, I finally found I could accomplish this -- for the most part -- with a Pivot Table. One of the key things was to turn off all subtotals and grand totals, plus show in tabular form. Not ideal, but works pretty darn good, and gets refreshed with master data. FYI.

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Reid,

    To copy only the columns you want you use just those column headers in the Extract (destination) range. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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