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?

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Kidd3421 ,

    Use a copy row automation. Trigger the automation when locker revoked is checked. The row will remain in your main sheet. A copy will post to the destination sheet.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.