Linking filters

[AndyM]

Any help would be much appreciated

I have a reasonably large dataset which comprises of the following columns (plus some additional info going wider)

Col A - Company Name
Col B - Dept Name
Col C - Group Name

What I am looking to do is to set up a user based sheet with filters which are linked. By this I mean, the user would filter Col A to isolate all records pertaining to a given company. Then when they filter column B they will only get a list of Departments that are relevant to the selected Company and so on.

Can anyone advise me how best to set this up?

Thanks in advance

A

[Jacob Hilderbrand]

Try this.

• Select A1:C1 (or as many columns as you want)

• (From the Worksheet Menu Bar) Data

• Filter

• AutoFilter

• Select items from each filter drop down to filter your data

[AndyM]

Thanks for the quick response

Out of interest, is there a way that this can be done using list boxes. Where by the contents of list 2 are determined by list 1?

Thanks again

Andy

[Jacob Hilderbrand]

We can use Named Ranges and Validation Lists to do what you want. Check Here.

[AndyM]

Excellent - that will work fine

Thank you again

Andy

[Jacob Hilderbrand]

You're Welcome

Take Care