Thread
:
Apply same filter to all sheets in a workbook
View Single Post
#
7
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Apply same filter to all sheets in a workbook
if ws.name <"Summary" then
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"manfareed" wrote in message
...
Hi JF ,
How would I exclude the first worksheet. This is going to be a summary
sheet
with macro button which the user will click to filter.
Thanks
" wrote:
Hi Manir,
How's this do you?
Sub Filter_All_Sheets()
Dim WS As Object
For Each WS In Worksheets
WS.Range("A1:C10").AutoFilter Field:=2, Criteria1:="Tyson"
Next WS
End Sub
Change the Range, Field (2 = column B) & Criteria to suit
JF
On 30 Jul, 16:23, manfareed
wrote:
Hi,
I am after a macro which filters by a particular name eg. Tyson in
Column B
for all worksheets in a workbook.
I would be attaching this macro to a "macro" button so when the admin
click
the button the sheets are filtered for Tyson. If they click another
button
then the filter will apply to another name eg. ALI.
Please help with macro. I would record it but each month the sheet
names and
number of sheets will vary.
Thanks,
Manir
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett