Advance filter

[still learning]

Hi
I'm try to do an Advance Filter Query
I know that I have to have a title line and include it in the range of where the data is
I know I have to have another exact title line and first row included in the Criteria
I know I have to have a part or all of the title line for the "copy to"
Now the problem...
I only want to include a part of the data range (some of the bottom part)
The top part..about 200 rows..is before the dates I'm looking for
I only need to include the bottom 200+ rows
I can't figure out how to include the title row but not include what i don't need without making a new title row in the middle of the data
I thought about coping all to a new sheet and delete what i don't need, but I'm wondering if there is a better way

mike

 

[mart37]

In the Criteria area you can add a criteria for only the dates greater then the bottomdate.

 

[still learning]

Hi mart37
that will work
I didn't know I could do that
Thank you
mike