Filter values basis combo box values

[shahcu]

Hi,

With the great help of you guys I am about to get what I want. However, a small change is required in this code. What I want is say user has selected any three values in all the three combo boxes. When he clicks on Run button basis the combo box values a filter will run on Sheet1 and stores the complete output in Sheet2.

As of now what the code is doing is simply capturing the combo boxes values and storing it in sheet2.

Please help

Regards,

Shane

[davesexcel]

Hi,

With the great help of you guys I am about to get what I want. However, a small change is required in this code. What I want is say user has selected any three values in all the three combo boxes. When he clicks on Run button basis the combo box values a filter will run on Sheet1 and stores the complete output in Sheet2.

As of now what the code is doing is simply capturing the combo boxes values and storing it in sheet2.

Please help

Regards,

Shane

Hi,
This code for the command button Should work for you...

Please Login or Register  to view this content.

[shahcu]

Thank you so much ....

You guys are really great.

Regards,

Shane