Date criteria i want to pull the data

[Abhijeet]

Hi
I have data in excel from that data i want pull the element wise which date is before that data i want please tell me how to do this.In attach file i mention the criteria & expected result also.please help me

 

[Abhijeet]

I mention only one date criteria please tell me between 2 dates criteria for element wise

 

[Abhijeet]

Please help me in this problem

 

[NARAYANK991]

Hi Abhijeet ,

This is a straightforward application of Excel's Advanced Filter ; please go through the available information on the net , so that you need not depend on forum members for this.

See the attached file to understand how the criteria range has been created and used.

Narayan

 

[Abhijeet]

I use advance filter but if i want to pull data in another sheet or workbook then this function is not work .so please give me macro for this

 

[NARAYANK991]

Hi Abhijeet ,

I suggest you do some reading.

When you wish to execute the Advanced Filter , there is no reason why it will not work on another worksheet ; as far as working in another workbook is concerned , I do not know what this means.

If you can extract the results of the Advanced Filter to a new worksheet , you can always move this worksheet to a new workbook.

Narayan