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

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

You can use the Indirect function to refer to a named list.
If you have for example several complaints in a list A2:A8 named Comp.
U can use Data Validation for the List drop down arrows =Indirect(G2), where
G2 holds the string Comp.
G2 cell also has a Data validation list as well returning a different range
name for each string - and so on...

Regards
Robert McCurdy

"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

You many want to consider using Access for this.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/


"Robert McCurdy" wrote:

You can use the Indirect function to refer to a named list.
If you have for example several complaints in a list A2:A8 named Comp.
U can use Data Validation for the List drop down arrows =Indirect(G2), where
G2 holds the string Comp.
G2 cell also has a Data validation list as well returning a different range
name for each string - and so on...

Regards
Robert McCurdy

"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