Hi All, I have a workbook with 3 tabs. 2 data tabs & a summary. IN Col D of the data tabs I have a risk score. I'm looking for a way to automatically populate the summary tab with anything that has a risk score of 3 but not include a list of every Task in Col A in the workbook. For example if nothing has a risk score of 3, the table will be empty. If something has a risk of 3, the summary will populate the name of the task.
So someone could just look at the summary tab to get a general idea of what is at risk with out having to click through all the tabs. I'm open to other approaches if this is not the most practical. I've attached a sample workbook. Thank you for any insight you can provide.
Bookmarks