Extract records after specific date criteria

Following is the picture of criteria that will be referred at the time of extracting data.
In this example, any records that fall after the criteria date (>3/31/2015) will be retrieved
 
img29
 
Press ALT + A + Q for launching advance filter dialog box & follow the below ranges in the fields
 
img30
 
This example will extract the data that falls after the specific date.Refer below snapshot
 
img31
 
ADVANCE FILTER INDEX:

Introduction to Advance Filter
1. Using “And”, “Or” and Multiple Criteria
2. How to Filter Unique Records?
3. How to Use Wildcards?
4. Extract records after specific date criteria
5. Extract items between 2 Date’s criteria
6. How to extract data with specific text?
7. How to extract data to another worksheet using VBA?
 

Download E-Book

 
 

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.