Removing Absent People from a List

[Brown]

Good morning,
I am trying to wrap my mind around this, and I know someone here can send me in the right direction. I have tried xlookup and if formulas but I am not getting what I need.
I have two lists of students, one list is daily absences and one is After School Club. I need the students on the Absence sheet to be removed from the After School Club sheet. Student ID will be the connection between the two sheets not names. What will be the easiest way to make this happen? I will need to build a sheet to give to a school admin to check this, and recreate daily.

Thank you for your thoughts.
Brown

 

[Brown]

This shouldn't be an issue as long as you can set up the macro yourself. Once you enter the code provided, you can assign it to a button on the worksheet. All the user would then have to do it is click on the button for the code to run.

Thank you I will try this.
Have a great weekend
Brown