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
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