Move certain cells to another sheet automatically
I am trying to create a simple locker tracker. I would like to move the information from the row to a new sheet if the checkbox in the locker revoked section is checked. However, I want to keep the locker # and location of the locker in the primary sheet also. Is something like this possible to automate?