Need help on Macro

[Saibal Dutta]

Hi,

I have excel sheet with data fields country, vendor name, PO number, PO amount, Invoice amount and PO status, under PO status if have multiple criteria like Open PO, Closed PO, Disputed PO. Based on the file created under "Extract data using Advanced Filter and VBA", I have prepared a model using same tecchnique, everything is working fine except a scenerio where I want "all" (OPEN, CLOSED & DISTPUTED) PO to be shown. For example

Country - "India"
Vendor Name - "Mahindra"
PO Status - "All" (for all POs including "Open", "closed" & "Disputed")

I can't leave PO status field blank because sometimes I may need only "Open" or "Closed" or "Disputed"

Attached is the sample file for your reference.

Need help to resolve the issue.

Thanks

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[Saibal Dutta]

Thanks a ton, everything is working fine now. Thanks again