PDA

View Full Version : [SOLVED] Linking filters



AndyM
02-22-2005, 03:47 AM
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
02-22-2005, 04:14 AM
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
02-22-2005, 04:27 AM
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 :thumb

Jacob Hilderbrand
02-22-2005, 04:43 AM
We can use Named Ranges and Validation Lists to do what you want. Check Here (http://www.vbaexpress.com/forum/showthread.php?t=1098).

AndyM
02-22-2005, 04:50 AM
Excellent - that will work fine

Thank you again

Andy

Jacob Hilderbrand
02-22-2005, 04:58 AM
You're Welcome :beerchug:

Take Care