Jul 24 2021 03:09 PM
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!
Jul 24 2021 07:00 PM
SolutionYou 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.
Jul 25 2021 11:38 AM
Jul 25 2021 06:52 PM
You're welcome @SaremAmmar! Glad it worked as desired.
Thanks and you too.
Jul 24 2021 07:00 PM
SolutionYou 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.