VBA Filter

stanco

New Member
Joined
Mar 16, 2019
Messages
26
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:
NameProjectGenderTypeFundingTopicDate of ApplicationSurvey Date 1Survey Date 2Survey Date 3Survey Date 4Survey 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 Datedd/mm/yyyy
Application End Datedd/mm/yyyy
NameProjectTopicDate 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 Date12/02/2019
End Date18/03/2019
NameProjectGenderTopicSurvey Date 2Survey Date 3Survey Date 4Survey Date 5
XXXXXXXXXXXX150/201903/03/201915/03/2019
XXXXXXXXXXXX03/03/201904/03/2019
XXXXXXXXXXXX08/03/2019
XXXXXXXXXXXX16/03/2019

<tbody>
</tbody>


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

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

stanco

New Member
Joined
Mar 16, 2019
Messages
26
Start Date12/02/2019
End Date18/03/2019
NameProjectGenderTopicSurvey Date 2Survey Date 3Survey Date 4Survey Date 5
XXXXXXXXXXXX03/03/201915/03/2019
XXXXXXXXXXXX03/03/201904/03/2019
XXXXXXXXXXXX08/03/2019
XXXXXXXXXXXX16/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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,471
Messages
5,468,820
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top