Debra has a lot of info on this. Pls do NOT label your request as "urgent".
All are treated the same here. Use a meaningful subject line instead. "Drop
down list help desired"

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gaurav" wrote in message
...
Hi

Actualy I have to make a complaint sheet for my office.

There are 3 departments in my office and each department have 3
sub-department.
Now I have to make a report that if i have any problem regarding any
department than first of all I have to select the main department from a
drop
down.Suppose if I would choose 1st department, it automaticaly locate all
the
3 departments which comes under 1st department, after that i have to
choose
my department from that list, and when i select my department there would
be
around 10 types of complaints and i have to choose one from that. it's
very
tought for me and i have been trying since morning but not able to make
any
report plz help me

you can send me ur suggestions on