Good afternoon. On Sheet2 of my workbook, I have a table that drives a data
validation list on sheet1. Sheet2 Col A has the status of Open or Closed.
Col B has the validation item list. So on sheet1, the list is only
populated with the Open items.

What I am trying to do is this - if the status of an item on sheet2 is
changed to Closed (and therefore removed from the validation list), how can
I find that item on Sheet1 and delete it in every cell that it occurs in? I
have heard of a worksheet change event, but not familiar with coding it.
Thank you in advance.