Forum Discussion
Solved
VBA Code does not work to filter Data based on the selection form drop down list
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:
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!
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.
3 Replies
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.
You're welcome SaremAmmar! Glad it worked as desired.
Thanks and you too.
