Need to do a series of advanced filters and have the advanced filters run down a range of cells to use as the criteria. For the first filter I'd like to use cells AF20:AF21 for the criteria, but for the second I'd like to use AF20 and AF22. Any ideas how to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Advanced Filter Help
- Thread starter Sylvan
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,305
- Office Version
- 365
- Platform
- Windows
I don't understand so I'm not sure if I might be able to help or not. Can you spell out in more detail what you have and what you want to achieve?
Are you looking for a macro to run the series of Advanced Filters?
Are you looking for a macro to run the series of Advanced Filters?
Upvote
0
