I wanT to extract Multiple-Records based on a condition.

Originally Posted by all4excel

I wanT to extract Multiple-Records based on a condition of dates falling in a range.

I have two tabs in the file Data and Vlookup.
Now what i want is to have the code pull the data for all the records which have a date one month in advance and 10 days after the

It works perfectly fine for the actul date showing all the records however what i want is to have a th current date and the records shown having the respective date one month in advance. and 10 days later

Like if today is 15-Aug-2007 then all the records with dates upto 14-Sep-2007 and any date till 5-Aug-2007 shouls show up.

I am attachIng a file to give and idea, which has a drop-down of dates which works perfectly well now what i want is to only have two options in the list of "All" to show all the records and the second option in the drop down would be the current date [ =TODAY() ].
--------------------------------------------------------------------------

I want to get all the dates falling in between a particular range like 1o days from the currrent date and 30 days ahead of the current date..
For Ex :- If today is 15-aug-07 then i want any dates within in 5th_aug to 14-Sep, Please make a note that the year is not to be considered while calculation.