Originally posted by Richie(UK)
Just for reference, there is a 'cheats' way that I found of using multiple criteria with AutoFilter (AF). However, it isn't very efficient as it involves repeated calls to the AF.
If you are interested, AF on your first 2 criteria and set a range equal to the visible cells. Now repeat the process with the next set of criteria and add the visible cells to the previous range using the Union method. With Screenupdating off and relatively small amounts of data this approach is 'workable' - haven't tried it with large amounts of data!
Video Tutorials / Excel Dashboards Reports