VBA to select filter criteria without deselecting current criteria

[jlal1990]

Hi guys,

I currently have a sheet with a column that has different filterable criteria (eg Education, How to, Gaming, Style, Film)

I recorded a macro to filter by the criteria 'Film' - however I dont know how to make it so that if I make another macro for 'Gaming', it will not deselect 'Film'. The aim is that i will have two macros - one for film and one for gaming , and if i click both macros - both filters will be applied. If i click one, only that one will be applied etc.

This is what i have so far:

Sub FILMfilter()


Sheets("Master Locator Data").Select
ActiveSheet.Range("$A$1:$AQ$30000").AUTOfilter Field:=9, Criteria1:= _
"Film"
Sheets("Functions").Select

End Sub

Thanks again!

 

[mole999]

have you tried selecting on both in your macro recording ? its should produce and AND Criteria2:= _
"Gaming"

 

[jlal1990]

Thanks for your help! I have but i dont want it to always return those 2 results, i would like it to be adaptive. I would essentially like it to perform the same function via macro as filtering and selecting new options whilst keeping others active each time.

 

[mole999]

three macro buttons, or a marker to direct how the macro records