Excel to do list Macro

[SimonM3]

greetings all. Excell Vba Noob here

I have a list of tasks within an excel spreadsheet (worksheet is entitled Tasks Outstanding), column G is Titled "Completed" with the answer Yes or No.
I would like to create a macro that checks for "yes" in this column and then moves that row A through G to another work sheet called Completed tasks, and If "No" leaves the row in the tasks Outstanding worksheet.
There are approxiamately 100 tasks on this list.

What would be the best way of approaching this

Thank

SimonM3