Filters with choices based on previous selection

Andy D 2002 · May 16th, 2002, 05:25 AM

Hi
i have a table with a number of columns e.g.
Col A Col B Col C etc
****** ******* ********
Client A A 1
Client A A 2
Client A B 1
Client B B 3
Client B C 9
Client C etc

i want 3 filters:
filter 1: user chooses Clients listed in Col A
filter 2 and 3: users only see choices for, say, Client A if choose A in filter 1

might be a pivot table i need?

any emailed examples or useful websites with examples appreciated
thanks
Andy

Chris Davison · May 16th, 2002, 10:01 AM

Hi Andy,

I'm not clear why autofilter doesn't already meet your requirements....

is there more to this ?

May 16th, 2002, 05:25 AM	#1
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	Hi i have a table with a number of columns e.g. Col A Col B Col C etc **** *** ****** Client A A 1 Client A A 2 Client A B 1 Client B B 3 Client B C 9 Client C etc i want 3 filters: filter 1: user chooses Clients listed in Col A filter 2 and 3: users only see choices for, say, Client A if choose A in filter 1 might be a pivot table i need? any emailed examples or useful websites with examples appreciated thanks Andy __________________ Andy Devine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 10:01 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Andy, I'm not clear why autofilter doesn't already meet your requirements.... is there more to this ?