Hello all, I am currently working on a VBA script that must automatically filter a worksheet with 4 criteria. I only want rows to be shown that include any of the 4 strings. Since there are more than 2 pieces of criteria I know I must use advanced filter, but I want the desired filter criteria to be pulled from a separate workbooks sheet, I cant figure out how to do this.
My current sketchy method (that works but is not ideal) includes having the macro input the header and filter criteria into some far off column within the sheet I am sorting and then execute an advanced filter with that data.
My current sketchy method (that works but is not ideal) includes having the macro input the header and filter criteria into some far off column within the sheet I am sorting and then execute an advanced filter with that data.