This was a great first go at it! The issue update looks to be running great, but there were a few issues with the risks update ... See below:
1) I forgot to add the Status column to the risk tracker sheet. If that could be added to the criteria that would be great.
2) If you run the macro multiple times the updates to risk tracker on the status page will continuously add empty rows. After about the fifth run of the macro it acts funky and begins to insert rows formatted like the header. If you hit the macro enabled button 5 times you will see what I mean.
I've attached a copy of the workbook with the macro created for your reference. Thank you so much for you help on this. It's so close!
TJH
Bookmarks