1- "F" would already be there ...spread around the spreadsheet.

2- I will not copy to another sheet but just this one.
This will allow the user to see what they want "quickly" and take action as
necessary.

3 - Once finished the filtered portion would show  "F" as "Alert SO the HR
department know that they should be doing something.

4 - HR will be updating a similar spreadsheet  each month and then running the
macro to check for action points.