How can I create a Macro that will move a row from one sheet to another based on its cell value

[jlsrexcel]

So I currently need to help someone with this issue, the spreadsheet is below:

To Do List is row 1. I want to move all the rows which says 'YES' in the complete column, for example, F6 says YES, so I want to move row 6 from the sheet 'Open Tasks' to a new sheet called 'Completed Tasks'. Please could you help me create a Macro for this?

To Do List
Today's Date	Friday, 6 March 2020
Day	Priority	Task	Notes	Task Type	Complete	Completion Date
Thurs	Medium	Rave		Call	No	Tuesday
Wed	Low	Repeat		Meeting	No	Friday
Fri	High	Tennis		Sport	YES	Monday
Thurs	Medium	Rave		Call	No	Tuesday
Wed	Low	Repeat		Meeting	YES	Friday
Fri	High	Tennis		Sport	No	Monday

 

[JLGWhiz]

Assuming that the Yes/No appears in column F starting at row 2.

Sub t()
Dim c As Range
    With Sheets("Open Tasks")
        For i = .Cells(Rows.Count, "F").End(xlUp).Row To 2 Step -1
            If LCase(.Cells(i, 6).Value) = "yes" Then
                .Rows(i).Copy Sheets("Completed Tasks").Cells(Rows.Count, 1).End(xlUp)(2)
                .Rows(i).Delete
            End If
        Next
    End With
End Sub

 

[jlsrexcel]

Here is a screenshot of my file below. What would I do in this case?

 

[jlsrexcel]

I copied and pasted the Macro, but it returns the error "Compile Error: Can't find project or Library"

 

[JLGWhiz]

I copied and pasted the Macro, but it returns the error "Compile Error: Can't find project or Library"

When the error appears, open the vb editor, Alt + F11, then click 'Tools' on the menu bar then click 'References'. Find the missing Libraty reference and click the check box. That should make the error go away. Click on link for full description by MS.

Can't find project or library

Office VBA reference topic

docs.microsoft.com

If you have not used VBA before, you might need to make sure all of your security settings have been adjusted. To do that , in Excel click File >Options>Trust Center>Trust Center Settings>Macros and select the options that allow you to use VBA.