I am trying to filter and extract data from Sheet"Data" depending upon multiple criteria entered in a separate Sheet"Filters". However, as some of the criteria fields in Sheet"Filters" are empty, the data returned is empty. If there a way to ignore if one of the criteria entered is empty and continue with data filtering with other criteria and return data? The following is the code I wrote so far:
Please Login or Register to view this content.
Bookmarks