Hi all,

I have to keep track of people who have over 80% attendance to meetings so that they can qualify for awards.

I have one sheet that has a list of every person (hundreds of them) along with a bunch of data about them (e.g. address, office location, the frequency of their attendance and the percentage of meetings that they have attended etc.).

I want to have a SEPARATE sheet that auto-populates its rows with the name and other data related to each person OVER 80%. If at some point they fall below 80%, I need them to be automatically removed (and vice-versa).

Is this something for VBA? What is the best way to approach this problem?

Any help would be very appreciated.