filtering with a macro button

[bvanscoy678]

Hello,

I don't know a lot about macro's but gonna try to pull this off.

What I want to do is insert the macro button,
then assign it to filter by AM, PM (the shift column) and also a button for clear all. I have 5-6 of these areas on a sheet, so can't use just filter. Plus some guys that are using, really don't know anything about excel, so thought I button would work good.

I have done marco stuff, but not sure how to assign it a range and set the criteria. Any ideas, links or previous projects would be greatly appreciated.

thanks
Brent

 

[pedie]

Is there anything else you want to do apart from sorting the table by AM/PM?
If so please state it...thanks

Do you mean sorting the table by AM or PM?
if you click on AM all the am will be in TOP region and if PM then PM?
What do you want to clear off when you click on the 3rd button
pedie

 

[pedie]

macro 1 is to filter by am
macro 3 is to file by pm
macro 2 is to remove

place the code in the command button accordingly and it should work...

hope this help

Sub Macro1()
'
' Macro1 Macro
'
'
    Range("A4").Select
    Selection.CurrentRegion.Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$3:$H$16").AutoFilter Field:=5, Criteria1:="am"
    Range("A3").Select
End Sub
---------------
Sub Macro3()
'
' Macro1 Macro
'
'
    Range("A4").Select
    Selection.CurrentRegion.Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$3:$H$16").AutoFilter Field:=5, Criteria1:="pm"
    Range("A3").Select
End Sub
 
 
-----------
Sub Macro2()
Range("A4").Select
    Selection.CurrentRegion.Select
    Selection.AutoFilter
 range("A1").select
 
End Sub

 

[bvanscoy678]

Yes, I am going to filter by AM or PM. So if I only want to see the AM shift or PM shift.

I'll try the first code for the macro.

Thank you