How do I change a value in one cell when there is a change?
 

Hello,
I have a school list that will go to about 20 supervisors for updating.
After I receive the multiple sheets I will need to merge and upload into a
database. I created a column (A) called "updated?" with a yes or no value to
pick from. I would like to have that value switched to yes whenever a cell is
updated on that row.

At the end of the day I would like to just autofilter and select those
schools that have been updated.

Thanks