Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    How to switch the categories in a RASI spreadsheet with the data

    Hi,
    I'd like to rearrange the RASI assignations in my chart to see the listing BY RASI category for EACH stakeholder, rather than the list of tasks crosshatched to all stakeholders. For example, instead of the emphasis on a listing of tasks with the RASIs assignments going across stakeholders, I'd like to take this same information, break it up by stakeholder, and list all the R tasks first, then the A's, S's, and I's so the stakeholder can get a quick understanding of how they are responsible (etc.) for each task. I'd use a pivot but my understanding of pivots is numerical, and this is text re-ordering and parsing. I've attached an example.
    Thanks! Help make my temp job pay off!
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I don't quite understand what you want. If you are only interested in Mgmt you create a custom sort list (R,A,S,I) and then sort by Mgmt item to get that order. I don't understand ultimately what you want the entire output to look like in the example.

    I agree that a pivot does not seem appropriate since I don't think it would make sense to average or sum the task numbers. Are you looking for a macro? if so, how different may the lists be?

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    naomi (2014-04-28)

  4. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Steve,

    I don't want just Management; I want a list for each stakeholder group. Taking a breather and looking at this again, I think I just have to manually pull it apart, make separate charts for each group and sort as you've said.

    thanks!
    Naomi

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,630
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Naomi,

    Here is some code that will list the way you had shown. You can add as many records to your table as you wish.

    HTH,
    Maud

    RASI1.png

    Code:
    Public Sub RASI()
    '-------------------------------------------
    'DECALRE AND SET VARIABLES
    Dim s As Variant
    s = Array("R", "A", "S", "I")
    LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
    Row = 4:: Count = 0
    '-------------------------------------------
    'SORT DATA
    For I = 0 To UBound(s)
        Cells(Row, 7) = s(I)
        Row = Row + 1
        Count = Row
        For J = 4 To LastRow
            If Cells(J, 2) = s(I) Then
                Cells(Row, 8) = Cells(J, 1)
                Row = Row + 1
            End If
        Next J
    '-------------------------------------------
    'NO MATCHING STAKEHOLDER GROUP
        If Count = Row Then
            Cells(Row, 8) = "-"
            Row = Row + 1
        End If
    Next I
    End Sub
    Attached Files Attached Files
    Last edited by Maudibe; 2014-04-28 at 21:40.

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    naomi (2014-04-29)

  7. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Wow Maudible, this is awesome! Exactly what I wanted! I don't know code well enough to write it, but I'm pretty sure I can figure out what to change for my other tables and pull that out too. Thanks so much!

  8. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,630
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Naomi,

    If you need help adapting it, feel free to Private message me.

    Maud

    P.S. Thanks for the thanks

Posting Permissions

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