Hi everyone.
I am trying to automate Advanced filtering option. The first few lines gives the criteria and the below table is actual data.

The number of rows in filtering can change dynamically based on the inputs given (it can be a single line or two or three lines).

Advanced filtering option requires no blank row. So the criteria table size should get adjusted based on the number of rows of criteria. I am a new to macro programming. Could you please check and let me know where I am making mistake in the code.
Thanks and appreciate your help.

Attached Files

check.xlsm (15.7 KB, 14 views)