How to view a list of data based on another list of data
 

In cell A1, I have a drop down list (created by Validation feature), this
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.

Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.

If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.

Thank you for any help/tip provided.
Adnan


--
Please post all your inquiries on this community so we can all benefit -
Thank you!

How to view a list of data based on another list of data
 

What you want is referred to as dependent Data Validation - check out
this link for ways of achieving it with standard Excel functions:

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

Hope this helps.

Pete

On Apr 10, 3:28 pm, Adnan (donotspam) wrote:
In cell A1, I have a drop down list (created by Validation feature), this
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.

Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.

If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.

Thank you for any help/tip provided.
Adnan

--
Please post all your inquiries on this community so we can all benefit -
Thank you!

How to view a list of data based on another list of data
 

Debra Dalgleish shows how to create dependent lists:
http://contextures.com/xlDataVal02.html

Adnan wrote:

In cell A1, I have a drop down list (created by Validation feature), this
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.

Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.

If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.

Thank you for any help/tip provided.
Adnan

--
Please post all your inquiries on this community so we can all benefit -
Thank you!

--

Dave Peterson

How to view a list of data based on another list of data
 

This is exactly what I needed. You guys are so nice and so helpful. Thank you
Pete, thank you Dave, you are very much appreciated.

Adnan
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Adnan" wrote:

In cell A1, I have a drop down list (created by Validation feature), this
cell has department listed such as:
Electrical Dept
Plumbing Dept
Etc.

Now, I am looking at having another drop down list in cell A2 which gives me
the data based on first selection, for instance; if I choose Plumbing on A1,
list me only issues for plumbing in A2 such as:
Fitting
Pipe
Threads
Etc.

If the other department, list the others for this corresponding department.
I know this is possible in access but am not sure for excel. Maybe with VBA
code it code work in excel, too.

Thank you for any help/tip provided.
Adnan


--
Please post all your inquiries on this community so we can all benefit -
Thank you!