I'm trying to build a simple RACI Model and have attached both a spreadsheet as well as a PPT view of what I'm trying to achieve.
1.) You put in a line item (ROW) and the spreadsheet automatically puts the data into the sheet.
2.) As the Priorities change, the list of Activities shifts to reflect the priorities
3.) The RASCI letters go into the matrix. Again, as the priorities change, the matrix changes.
Hopefully this is not too complex.
B. RASCI-Sheet.xlsm RASCI-Diagram.pptx