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)

name	dept	salary	city
mary1	it	71660	toronto
john1	hr	78386	montreal
alex1	hr	27720	ottawa
adam1	sales	82132	toronto

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






























</tbody>

 

[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