VBA Filter Array by Two date Criterias, Help!

Hello All,

I have an array with four columns of projects with start dates and end dates.
I am trying to create a user forum that generates a report based on the criteria of the Start and End date.

Can someone help me filter the array based on the two Criteria’s??

Example

Start Date (Column A)---Company Name(Column B)---Project Name(Column C)---End Date(Column D)
------12/01/2011------------------Company 1-----------------------Project 1--------------------12/05/2011
------12/05/2011------------------Company 2-----------------------Project 2--------------------12/10/2011
------12/10/2011------------------Company 3-----------------------Project 3--------------------12/15/2011
------12/15/2011------------------Company 4-----------------------Project 4--------------------12/20/2011


----Criteria-----
Start Date: 12/05/2011
End Date: 12/15/2011


----Result----

Start Date (Column A)---Company Name(Column B)---Project Name(Column C)---End Date(Column D)
------12/05/2011------------------Company 2-----------------------Project 2--------------------12/10/2011
------12/10/2011------------------Company 3-----------------------Project 3--------------------12/15/2011


I would like the result to NOT replace the original data

Thank you for your help!!


-Crebsington

Here's a quick example you could adapt to your needs...

Please Login or Register  to view this content.

HTH,
Rich

dangelor, Thank you for your post and your efforts.

This Code is almost perfect for my needs. I would like the code to filter the data by the two criteria and all the data that falls between the two??

For Example:

I have Attached an example of what I would like the results to be if possible

In the attached file, I used dynamic named ranges for the Data and Criteria fields. Also, note the syntax of the criteria formulas.

Please Login or Register  to view this content.

HTH,
Rich

This Works Great! Thank you!!

You're welcome!