Kris Nicole
New Member
- Joined
- Feb 27, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- MacOS
Hello,
I want to have a set of 4 live sheets within one Excel Workbook categorizing the status of an order: processing, ready, shipped, delivered. When the status of an order is updated, I would like orders to be automatically moved between sheets. What steps must be taken in order to achieve this?
For example, when an order changes from processing to ready, and I indicate that in Column A, could it be automatically cut from the “processing” sheet and pasted into the next available row of the “ready” sheet?
Thanks,
Kris
I want to have a set of 4 live sheets within one Excel Workbook categorizing the status of an order: processing, ready, shipped, delivered. When the status of an order is updated, I would like orders to be automatically moved between sheets. What steps must be taken in order to achieve this?
For example, when an order changes from processing to ready, and I indicate that in Column A, could it be automatically cut from the “processing” sheet and pasted into the next available row of the “ready” sheet?
Thanks,
Kris