Bright01
asked on
Chart Enhancement with Macro Change
EE Professionals,
I have a Chart that EE helped me create that needs an enhancement. Presently if you add a Task and assign it a number in the Critical Path, it will adjust the data but not the chart. It's also difficult to add tasks because the data is in line with the chart for part of it.
Can the "Update" macro be made automatic? So that when there is a change to the data and the "Enter" key is pressed, the table is automatically updated?
B.
RASCI-Sheetv3.xlsm
I have a Chart that EE helped me create that needs an enhancement. Presently if you add a Task and assign it a number in the Critical Path, it will adjust the data but not the chart. It's also difficult to add tasks because the data is in line with the chart for part of it.
Can the "Update" macro be made automatic? So that when there is a change to the data and the "Enter" key is pressed, the table is automatically updated?
B.
RASCI-Sheetv3.xlsm
ASKER
Teylyn,
Thank you for the quick response. It works great! Is there a way where the cursor won't revert back to the top? Thank you,
B.
Thank you for the quick response. It works great! Is there a way where the cursor won't revert back to the top? Thank you,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Teylyn! Great job. Thank you very much. I will most likely be asking a related question on this as this function continues to be built out. And I thought you said you were a formulas person!
Cheers,
B.
Cheers,
B.
Yeah, well, stretching and all :-)
Thanks for the grade.
Thanks for the grade.
You can combine the Worksheet_Change event and the macro that updates the RACI table.
Right-click on the sheet tab, click View Code to open the VB Editor
Double-click "Sheet1 (RASCI)" in the Navigation pane of the VBE
Scroll down to the end of the Worksheet_Change procedure and before the "End Sub" line enter
PopulateRasciTable
The last four lines of the code should now read
Open in new window
Now, whenever you add a row of data to the text table, as soon as you enter a number in column A, the row will be sorted into the data table, and an entry for that row value will be created in the RASCI chart. Whenever you edit the number, description or RASCI letter for a row, it will be reflected in the RASCI table.
cheers, teylyn