VadersKid
New Member
- Joined
- Aug 30, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hi all. Like the title suggests, I am looking to establish a VBA code for an Excel workbook or worksheet to be able to filter multiple columns at once.
For example: Based on the image I have provided, how could I filter all the "Yes" or "No" answers for each Quarter all at once. To elaborate, lets say I wanted to see all the "Yes" for Quarters 1 and 2 and all the "No" answers for Quarters 3 and 4. Is this even possible?
Also, is there a way I can apply this to the whole workbook, kind of like a blanket code for the whole workbook/worksheet, or does the code need to be dependent on specific columns? I have large amounts of data to filter from but primarily its the same criteria throughout the book and it would be awesome if I didn't have to apply a code for each column, if that makes sense. Any suggestions would be greatly appreciated.
For example: Based on the image I have provided, how could I filter all the "Yes" or "No" answers for each Quarter all at once. To elaborate, lets say I wanted to see all the "Yes" for Quarters 1 and 2 and all the "No" answers for Quarters 3 and 4. Is this even possible?
Also, is there a way I can apply this to the whole workbook, kind of like a blanket code for the whole workbook/worksheet, or does the code need to be dependent on specific columns? I have large amounts of data to filter from but primarily its the same criteria throughout the book and it would be awesome if I didn't have to apply a code for each column, if that makes sense. Any suggestions would be greatly appreciated.