Filter Data with Criteria

[rizmomin]

Hello:

I have very large excel sheet with 30,000 rows of data.


The main data is in column A thru J where


Column B : Invoice #
Column C : Invoice Amount
Column H : Amount Paid ( If this cell is blank then it means it is unpaid invoice)

I want to get the list of all unpaid invoices by choosing Client name and Invoice amount table from drop down list.

Please refer to attached sheet with sample data.
I have manually entered the data is sheet3 ( Select Client name from Cell A1 and invoice amount in Cell A2

Let me know if you have any questions.

Thanks and looking forward for help.

Riz

[JieJenn]

You might want to reformat your filter table. Look the attached. The code is just an example. Modified based on your needs.

Please Login or Register  to view this content.

[rizmomin]

Hi Jie:

Thanks for your help.
It looks like it is malfunctioning.
Please refer to attahced sheet and have a look at Sheet1 (2 highted field as unpaid)
However running macro only gives 1 result.

Riz

[JieJenn]

One is Kelly, one is warren. The criteria you specified only has one result.

[rizmomin]

Hi :

I am sorry, you are correct.
Let me do some more testing and will let your know.
I surely appreciate your great help/.

Riz

[rizmomin]

Hi :

I am still confuse, how to reslove my problem.
Can you please help solve the problem.
Please understand my thread and would appreciate if someone can problem a macro to complete my task.

Thanks a lot

Riz

[rizmomin]

Hi :

I think i have resolve the problem.
I would contact you if further help is needed.
However, thank you so much for help.

Thanks
Riz