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