I have absolutely NO clue about excel. I am self taught in the limited knowledge i do have.
Can someone please, blow by blow, explain how to do something...
I have several fields on the 'OPEN' tab. Each MUST be populated, and the S column has a dropdown box saying Complete, which must say this before moving the whole row to the 'CLOSED' tab.
Similiarly, if someone wants to reopen the case, there are several other options apart from Closed, ie open, quarantine etc, and if the status is reopened in any way and it doesnt say the word closed, i want it to move back to the top row of the 'OPEN' tab sheet...
Can someone please tell me what to do, bit by bit...
Thank you!
Sheet attached
Bookmarks