Multiple Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have multiple criteria(in this case 2) in the criteria box of the advanced auto filter
I have my defined name in there but I also want it to extract criteria from a diffrent worksheet. I would see I would need some 'and also' formula.
Thanks
 
You can only have one criteria range. However, you could add links to
the second criteria in the first range, then select that expanded range
as the criteria area.
 
Maybe there is a simpler way (somewat automated)of doing this. I set up a database(sheet1), I then have a separate sheet(sheet2) where Advanced Filter takes my info from the database for current week , then I have another sheet(sheet3) that gets more information from the database but the criteria is now in sheet2, I have a macro doing this for me and it works great. But I would also like to combine sheet3 information with all the information for my current week. What the macro is doing is filtering the current weeks addresses that are duplicates from previous weeks extracting them to sheet2, then sheet3 is filtering new criteria (which are the addresses that were filtered) and gets every duplicate that matches that address and extracts it to sheet3. I want that current week info all on one sheet.
 
Back
Top