View Single Post
 
Old 08-24-2010, 01:13 PM
massi massi is offline Windows XP Office 2003
Novice
 
Join Date: Aug 2010
Posts: 1
massi is on a distinguished road
Default drop down menu that control filter on other column

hello,

i have a cell which has a list of several choices let's say in A1.

values are:
value01
value02
value03

row 5 has the header of several columns (A,B,C)

header01 | header02 | header03
---------------------------------
2011 | alpha | value01
3011 | alpha | value02
3333 | alpha | value02
4521 | alpha | value01
2011 | alpha | value03
2001 | alpha | value03
0011 | alpha | value01
7711 | alpha | value01

i would like to have the list in cell A1 controlling the filter for header03

i have looked the whole day in the i-net but i could not find a solution.
anyone can help me?

thanks
massi
Reply With Quote