I have attached a working spreadsheet but need to add more functionality.
1. If my High Risk (Red) changes and I make the R and I it then needs to copy
the entire row to the issues tab and grey out row text or whole row background on the Open Tab for the row that has just changed. I also has to keep the same # Number it had on the Open tab when showing on the Issues tab
2. When you are on the Issues tab and you close
the issue, it must then move
the entire row and its contents from the Issues tab back to the Open tab, replacing the row that has the same number on the Issues tab.
If it is just a standard Issue, it will follow the same rules as in steps 1 and 2
Hope this makes sense