multiple list

[lezawang]

Hi
Can I create multiple list. For example a list like this

XXXX ---> {it, hr, marketing, sales}

XXXX {name, dept, salary, city}

if user select dept then list of dept will show, if user select Name, then list of names will be listed, if user select Salary, then list of Salary will be listed, If user select City then list of city will be listed.

Is that possible? I can create one List only (one dimension list only)

[TABLE="width: 256"]


<colgroup><col width="64" style="width: 48pt;" span="4">
<tbody>[TR]

[TD="class: xl63, width: 64, bgcolor: transparent"]name[/TD]

[TD="class: xl63, width: 64, bgcolor: transparent"]dept[/TD]

[TD="class: xl63, width: 64, bgcolor: transparent"]salary[/TD]

[TD="class: xl63, width: 64, bgcolor: transparent"]city[/TD]

[/TR]

[TR]

[TD="class: xl63, bgcolor: transparent"]mary1[/TD]

[TD="class: xl63, bgcolor: transparent"]it[/TD]

[TD="class: xl63, bgcolor: transparent"]71660[/TD]

[TD="class: xl63, bgcolor: transparent"]toronto[/TD]

[/TR]

[TR]

[TD="class: xl63, bgcolor: transparent"]john1[/TD]

[TD="class: xl63, bgcolor: transparent"]hr[/TD]

[TD="class: xl63, bgcolor: transparent"]78386[/TD]

[TD="class: xl63, bgcolor: transparent"]montreal[/TD]

[/TR]

[TR]

[TD="class: xl63, bgcolor: transparent"]alex1[/TD]

[TD="class: xl63, bgcolor: transparent"]hr[/TD]

[TD="class: xl63, bgcolor: transparent"]27720[/TD]

[TD="class: xl63, bgcolor: transparent"]ottawa[/TD]

[/TR]

[TR]

[TD="class: xl63, bgcolor: transparent"]adam1[/TD]

[TD="class: xl63, bgcolor: transparent"]sales[/TD]

[TD="class: xl63, bgcolor: transparent"]82132[/TD]

[TD="class: xl63, bgcolor: transparent"]toronto[/TD]

[/TR]


</tbody>[/TABLE]

 

[arthurbr]

Just use the Autofilter ?

 

[lezawang]

Autofilter?

No what I want to create this list so depend of the selection I will highlight the row in that table. For example if user select Dept and then HR then the whole row which has HR will be highlighted. If user select City then Toronto then the rows with Toronto city will be highlighted. Etc. Thank you.

 

[Finalfight40]

Hi Leza

I used this today but is this what you are looking for?

http://www.contextures.com/xlDataVal02.html