Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Autofilters
I have a workbook with 3 worksheets.
Each worksheet has a column with Region as the heading. I would like to be able to use autofilter on the first worksheet and have the same region selected as the filter on the other two worksheets. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Autofilters
Hi RobinG
You can do this to filter each sheet with the same criteria Sub Autofiltertest() Dim FilterValue As String Dim sh As Worksheet FilterValue = "UK" For Each sh In Sheets(Array("Sheet1", "Sheet2", "Sheet3")) With sh .AutoFilterMode = False .Range("A:A").AutoFilter Field:=1, Criteria1:=FilterValue End With Next sh End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "RobinG" wrote in message ... I have a workbook with 3 worksheets. Each worksheet has a column with Region as the heading. I would like to be able to use autofilter on the first worksheet and have the same region selected as the filter on the other two worksheets. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilters | Excel Worksheet Functions | |||
How to set up AutoFilters? | Excel Worksheet Functions | |||
autofilters | Excel Worksheet Functions | |||
VBA and Autofilters | Excel Programming | |||
Userforms and autofilters - Autofilters don't seen to work with userform | Excel Programming |