Automatically Refresh an "AutoFilter"

[pyronaya]

Hello,

I have a workbook that has different product lines on separtate worksheets. Also there is one summary worksheet that contains an "AutoFilter".

Is there a way to have that Summary worksheet "Refresh" its AutoFilter whenever it is opened?

Thanks!!

 

[Domski]

Hi,

You could use a Worksheet_Activate event like this:

Private Sub worksheet_activate()

Range("A1").CurrentRegion.Select

Selection.AutoFilter Field:=3, Criteria1:="Andrews"

Range("A1").Select

End Sub

In this example surnames are listed in column C and the filter applies to show only individuals called Andrews.

The code should be placed on the worksheets module. To open this right click on the worksheet tab and past the code in the resulting window.

It won't work if people don't enable macros when opening the document though.

Hope it helps.

 

[pyronaya]

AWESOME!!!

Thanks Domski....I really need to buy a VBA Macro book from Mr. Excel.

Have a good one.