Hi, I am trying to learn how to move records based on their status.
I have a simple setup with two worksheets - Active Orders and Completed Orders.
If an active order has the status of 'Active' - it should only display on the Active Orders sheet. If the status is changed to 'Completed', it should only show on the Completed Orders sheet.
The record should move immediately as soon as the value is changed.
Also - on my Completed Orders sheet - the existing records are sorted by Date. The incoming active order should position itself correctly based on the date value.
Lastly - if the status is changed back to Active Order (from the Completed Orders sheet) - it should switch again.
https://docs.google.com/spreadsheets...it?usp=sharing
Thanks in advance for any help.
Bookmarks