Hi I have created an advance filter to filter out some values, but scenario where the macro does not find the filter criteria values in the excel sheet, it hides all the other rows hence wanted to check how I can make a macro in such a way that if it doesn't find the filter criteria value in a column it should move to another criteria rather than just hiding the whole row