Advance Filter

[sachar]

Dear All,

With reference to the attach sample file, I would like to drag the detail from “Data” Sheet to “Sheet1” with the help of Advance Data Filter only that have “[Against Pkg.: P-BF1]” in the column “I” of “Data” Sheet.

Please help me how to sort out my problems?

 

[Hui]

1. Add field Names to all the Database Fields Field1 etc

2. I named the Database d

3. Setup the criteria in Sheet1!I1:I2 as


4. Setup the Field names you want to retrieve in M1:U1

5. Run the Advanced Filter


enjoy

Or setup a macro to do it

see attached file

 

[sachar]

Dear Hui,

You are so great, Thanks for sort out my problem.

Thanking you.