VBA Filter

[stanco]

Hi, i need some help on two matters. both are related to filters, involving dates and multiple column.

a sample of my database as such:

Name	Project	Gender	Type	Funding	Topic	Date of Application	Survey Date 1	Survey Date 2	Survey Date 3	Survey Date 4	Survey Date 5

<tbody>
</tbody>

i need to generate two lists from this database quite frequently and i am hoping to automate it.

the first list is relative simple, i just need to filter gender and date of application, and i am hoping to extract all the corresponding rows into a fresh sheet whenever i key in the date range (at the fresh sheet itself). for example,

Application Start Date	dd/mm/yyyy
Application End Date	dd/mm/yyyy
Name	Project	Topic	Date of Application

<tbody>
</tbody>

the second list is more "complicated". the surveys are done on an adhoc basis so some might be on survey 4 but some might be on their first or not even started yet. i need to filter the rows based on a date range for the survey columns (starting from the second survey onward) that falls between the date range. (is this even possible?)

Start Date	12/02/2019
End Date	18/03/2019
Name	Project	Gender	Topic	Survey Date 2	Survey Date 3	Survey Date 4	Survey Date 5
XXX	XXX	XXX	XXX	150/2019	03/03/2019	15/03/2019
XXX	XXX	XXX	XXX	03/03/2019	04/03/2019
XXX	XXX	XXX	XXX	08/03/2019
XXX	XXX	XXX	XXX	16/03/2019

<tbody>
</tbody>

or is there any better way to do this? appreciate your help and suggestions on this please!

 

[stanco]

Start Date	12/02/2019
End Date	18/03/2019
Name	Project	Gender	Topic	Survey Date 2	Survey Date 3	Survey Date 4	Survey Date 5
XXX	XXX	XXX	XXX		03/03/2019	15/03/2019
XXX	XXX	XXX	XXX	03/03/2019	04/03/2019
XXX	XXX	XXX	XXX	08/03/2019
XXX	XXX	XXX	XXX	16/03/2019

<tbody>
</tbody>

sorry, i cannot edit my earlier post, but the second list should be like this. it should shows all the details and the dates of the surveys that meet the date range. for earlier surveys that were done outside of the date range, it should not be shown.