Moving row of data automatically to another tab based on drop down selection

[laptopdoritos]

Hello everyone,

I am trying to do what the title says in Google sheets. If this isn't the right location to ask a question about google sheets, I apologize in advance. Whenever the status changes to complete, I would like it if that specific row automatically moves from the Current Projects tab to the Project Archive tab. I have seen I need to use scripts but I am still learning how to use it. I appreciate the help that this community can provide me with.


Link to my google sheet: Project Tracker Example