Multi-filtering per worksheet

[PsyberFox]

Hi there,

Is there a way to use the data filtering function on more than one "table"
of information per worksheet?

I have info from let's say A1:L30 and some other information from A40:L60.
When I filter the first part, it works fine. However, when I filter the
second "table" of information, it disables the first one, and re-filters the
second lot of data.

Thanking you in advance,
W

 

[Don Guillett]

I don't think so but something like this would work with a defined named
range in a sheet module.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("a12").Address Then
Range("mfr2").Rows.Hidden = False
For Each c In Range("mfr2")
If c <> Target Then Rows(c.Row).Hidden = True
Next
End If
End Sub

 

[Gord Dibben]

If you use xl2003's Data>List>create List function for both tables you can
sort and filter either.

In xl2007 this would be Insert>Table


Gord Dibben MS Excel MVP