PDA

View Full Version : Sleeper: Listbox value from excel filter



tommy1234
03-14-2011, 02:15 AM
hello
i have an excle table with many columns.
i add 2 list box :
the first one contains all the projects managers name
the second on the projects name
i want to filter the second listbox according to the selected data form the first listbox.
if i choose project manager name "joe" i'll be able to see only his projects.
i need to be able to do that for mulitple selection - choose a number of project managers.
remark : i read some solution on the internet based on pivot tables and i don't want to use pivot table.

thanks

Bob Phillips
03-14-2011, 03:54 AM
See http://www.contextures.com/xldataval02.html