SOLVED

VBA Code does not work to filter Data based on the selection form drop down list

Copper Contributor

I tried to filter the Data of the Table1 based on the selection of two dependent drop down list using a simple VBA code described as follows:

SaremAmmar_0-1627163928114.pngSaremAmmar_1-1627163981351.png

However, Filter process does not work properly. The result stuck with the row no.2!

Could you please help me with this problem?

I attached the excel file as a reference.

 

Thanks very much!

3 Replies
best response confirmed by SaremAmmar (Copper Contributor)
Solution

@SaremAmmar 

You need to change the setup slightly. The criteria range rows should not intersect with the data rows.

I have changed the setup in the attached and it works now.

 

@Subodh_Tiwari_sktneer
Many thanks for your swift response and support.
Have a great weekdays!

You're welcome @SaremAmmar! Glad it worked as desired.

Thanks and you too.

1 best response

Accepted Solutions
best response confirmed by SaremAmmar (Copper Contributor)
Solution

@SaremAmmar 

You need to change the setup slightly. The criteria range rows should not intersect with the data rows.

I have changed the setup in the attached and it works now.

 

View solution in original post