I want to create an Advanced Filter with a criteria range on a hidden worksheet. e.g. The filter is on sheet2 and the spreadsheet with all the information is on sheet2 But I’m not sure how to do this.

I also want the filter tool to be built using a dialogue box in sheet1 can anyone advise how I could do this.