Hi,
I need help on this VBA.
Here is my Code...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 3 And Target.Column = 3 Then
Worksheets("Data Entry").Range("Database") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Data Entry").Range("AA1:AA2"), _
CopyToRange:=Range("A6:R6"), Unique:=False
End If
End Sub

Instead of looking for match in one Column (Field),AA1:AA2 in this case. I need to have it look in multiple Columns.
Thanks in advance.
Pawan