VBA to filter by criteria

[asjmoron]

Hey guys,

I am trying to write a VBA way of filtering between two dates and by one criteria.

For exmaple,

I have a data on a sheet called "Sales Data" and date fields that are set in two different cells and a name in a third cell on "Dashboard". I want to be able to filter "Sales Data" based on the selections on the Dashboard Page...

Any thoughts?

 

[asjmoron]

Ive sussed it now!

if you are interested this what I ended up with

Public Sub SalesFilter()
Dim lngStart As Long, lngEnd As Long, IngAgent As Long


lngStart = Sheets("DashBoard").Range("J4").Value 'Start date
lngEnd = Sheets("DashBoard").Range("J5").Value 'End date
lngAgent = Sheets("DashBoard").Range("F5").Value 'Agent Name

Sheets("Sales Data").Select

Sheets("Sales Data").Range("A1:R1").Autofilter Field:=18, _
Criteria1:=">=" & lngStart, _
Operator:=xlAnd, _
Criteria2:="<=" & lngEnd

Sheets("Sales Data").Range("A1:S1").Autofilter Field:=19, _
Criteria1:="=" & lngAgent

End Sub