Filter based on multiple criteria in other sheet

Hello,

I am trying to write a macro to filter based on multiple criteria from other excel sheet.
I want the code to select the column from the criteria sheet and filter in the main sheet. The criteria should be ends with and criteria sheet.

Let me know if there is any code. I want to keep the criteria sheet as separate sheet as the exceptions can be added and deleted as required so that I dont want to alter the code everytime there is any change.


Thanks in advance.

I could find the solution but need modification to this code. Hope someone could help me.

Please Login or Register  to view this content.

This code will filter from the array, but I want the array values to be picked from other sheet(criteria) and filter should be case sensitive.