Copy Contents of Column B only if A & C fit rule

[KaraLynn]

I am trying to create a auto populate to-do list. The information is to populate into Sheet 1, from Sheet 2. Sheet 2 has three columns: (A) Priority (B) Task Description (C) Complete?

I want Sheet 1 to verify that columns A & C fit specific rules, then copy the description in B. For example:

Sheet 1, under the column 3, needs all tasks with a priority level of 3 and has not been completed to populate into that column.

Help?

 

[VoG]

Maybe

Sub test()
Dim LR As Long, i As Long
With Sheets("Sheet2")
    LR = .Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To LR
        If .Range("A" & i).Value = 3 And LCase(.Range("C" & i), Value) Like "*completed*" Then
            .Rows(i).Copy Destination:=Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1)
        End If
    Next i
End With
End Sub

 

[KaraLynn]

Thank you, I will try that.