VBA code for filtering multiple columns

[VadersKid]

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.

 

[mumps]

I don't think that is possible. You would have to put each quarter in its own separate sheet.

 

[mumps]

Although you can't filter the data in only one column, you can sort the data in only one column so all the Yes's and No's would be together.

 

[VadersKid]

That's a bummer. But, I appreciate you taking the time to respond.

 

[mumps]

My pleasure.