Jenniferzp9
New Member
- Joined
- Jun 14, 2022
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
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 down selection? And also move it back from “Settled” and into “Clients” worksheet if need be?