View Single Post
 
Old 07-17-2018, 12:20 AM
kannan14 kannan14 is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2018
Posts: 1
kannan14 is on a distinguished road
Default Automating Advanced filtering

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
File Type: xlsm check.xlsm (15.7 KB, 14 views)
Reply With Quote