Job description
I have two sheets within one file, let's call them sheet 1 and sheet 2. In sheet 1 there are a lot of rows and columns. However, one of the columns is important and is supposed to define a change. There is a select thrown in there with a checkbox of 3 statuses. Let's call them open, closed, paid. I would like to have the data automatically move to sheet 2 when closed or paid status is set, leaving in sheet 1 the data with open status only.
Please give me suggestions on how this could be done. This is not to be a one-time action, as I work on the file regularly.