Move rows to another sheet when value is chosen from a drop-down menu in cell

Hi Dear Excelforum users this is my first post, please be kind to me

This is my first time using VBA so i am a complete noob, i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved
if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template Thank you

EDIT: sorry i forgot to mention that i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet. Sorry if i suck at explaining the issue i think seeing the file will help explain better

Do you want the complaint moved (cut from sheet) or copied?

Try this:

Please Login or Register  to view this content.

By the way, you have a typo in one of the sheet names. Correct it before you run the code or the code will fail.