Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hello,
I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office.
Many Thanks
I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office.
VBA Code:
Sub Office()
'
' Office Macro
'
'
ActiveSheet.Range("$A$1:$D$46").AutoFilter Field:=1, Criteria1:="*Office*"
ActiveWindow.SmallScroll Down:=-6
End Sub
Sub Yard()
'
' Yard Macro
'
'
ActiveSheet.Range("$A$1:$D$46").AutoFilter Field:=1, Criteria1:="*Yard*"
ActiveWindow.SmallScroll Down:=-6
End Sub
Sub Transport()
'
' Transport Macro
'
'
ActiveSheet.Range("$A$1:$D$46").AutoFilter Field:=1, Criteria1:="*Transport*"
ActiveWindow.SmallScroll Down:=-6
End Sub
Many Thanks