I work for people who are excel stupid. According to my boss, they cannot use the autofilter. So he wants a button.
I want to design a button that when pushed would
go to the data worksheet perform a autofilter on the item then copy and paste the data into the worksheet with the button on it.
I have 19 filter items so I guess I need 19 buttons with labels of each divisions.
Is there any way to have one button label Report and the users choose their own division?
I am working with this code but it is too choppy. Any Suggestions?
Help Please with my bosses.
I want to design a button that when pushed would
go to the data worksheet perform a autofilter on the item then copy and paste the data into the worksheet with the button on it.
I have 19 filter items so I guess I need 19 buttons with labels of each divisions.
Is there any way to have one button label Report and the users choose their own division?
I am working with this code but it is too choppy. Any Suggestions?
Help Please with my bosses.
Code:
Sub Button1_Click()
'
' Button1_Click Macro
'
'
Sheets("Status - Item Detail Report").Select
Selection.AutoFilter Field:=1, Criteria1:="Administration"
Range("A1:H365").Select
Selection.Copy
Sheets("Sheet1").Select
Range("A22").Select
ActiveSheet.Paste
End Sub