I have an issue where I am trying to move data back and forth based on cell value. I currently have a drop down with the options PENDING, ACTIVE, & SETTLED. I have 2 sheets: Clients and Settled. Is there a way I can automatically move the data from “Clients” to “Settled” worksheet based on drop...