VBA Macro to copy values on other sheet based on condition

[mcane]

Hi People!
Sorry i'm very basic with macros, I have a vague idea but to be honest the last time I've done one was 8 years ago.
I think this might be simple, but I can't do it, so it would be really helpful if you guys can help me
I have a file with 2 sheets, one called "Recommendation Table" and the other "Close Out Plan"
So, I need to populate all the information from the "Recommendation Table" sheet into the "Close Out Plan" based on the value of the D Column of the "Recommendation Table" (if Column D=Critical or Essential, then I'd need to copy all the row, otherwise I need to check the next row).

Thanks in advance to everyone.
Miguel.

 

[My Aswer Is This]

Try this:

Sub My_Filter()
Dim ans1 As String
Dim ans2 As String
ans1 = "Critical"
ans2 = "Essential"
    With Sheets("Recommendation Table").UsedRange
        .AutoFilter
        .AutoFilter Field:=4, Criteria1:=Array(ans1, ans2), Operator:=xlFilterValues
        .SpecialCells(xlCellTypeVisible).Copy Worksheets("Close Out Plan").Range("A1")
        .AutoFilter
    End With
End Sub