Hello - Any chance someone has code that would allow the following.

In sheet1 I have a list of names that are being added as active
members. When the members leave or terminate, we enter the word
"terminated" in a column titled "Status."

What I need is a record of all names that were terminated (on a
separate sheet). So, ideally, I can come up with code that will
automatically feed (a copy of) that entire record to a separate tab in
that workbook, upon the changing of the status in that column to
"terminated". The name of that other sheet is "Terminated Members."

I will need that list of terminated members to stay in the "terminated
members sheet", although I will eventually delete the entire record
from from the Active Members sheet.

Any code that would assist (or that is used for a similar set of
circumstances) would be greatly appreciated.

Thanks.