Good morning,

In my Excel sheet, I have two fields: Project Type (B2) and Type of Work
(B4). Currently, I use Validation on both fields to have a drop-down for a
list of items. What I am hoping to do is, for example, if I select Project A
from the Project Type field, I only want Cell B4 to list the types of works
that apply to Project A, instead of listing entire list.

Can it be done?

Thanks.

John,

Thanks very much for your help.

I am very new to this. Can you help me more?

Currently, the validations on these two cells are looking up from the
Project Type sheet and the Type of Work sheet, respectively. If I understood
correctly, I should have only one sheet with the combination of Project Types
and Types of Works. Am I correct?

Can you tell me more on setting up the sheets and the code to use?

Thanks.

"John Bundy" wrote:

You can give a specific list based on project type
if A is selected you could use list in column a and if B then list in column b

Range("e5").Validation _
.Modify xlValidateList, xlValidAlertStop, _
xlBetween, "=$A$1:$A$10"

-John

"AccessHelp" wrote:

Good morning,

In my Excel sheet, I have two fields: Project Type (B2) and Type of Work
(B4). Currently, I use Validation on both fields to have a drop-down for a
list of items. What I am hoping to do is, for example, if I select Project A
from the Project Type field, I only want Cell B4 to list the types of works
that apply to Project A, instead of listing entire list.

Can it be done?

Thanks.

It doesn't really matter where you put the link at you just need a list for
if Project A is selected and one for if something else. How do you have it
set up now? If I select project A from the first validation, what cells do
you want to use to populate the list for the second? and another plan?

"Tom Ogilvy" wrote:

go to

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Look under data validation.

She specifically talks about this situation.

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

--
Regards,
Tom Ogilvy


"AccessHelp" wrote:

John,

Thanks very much for your help.

I am very new to this. Can you help me more?

Currently, the validations on these two cells are looking up from the
Project Type sheet and the Type of Work sheet, respectively. If I understood
correctly, I should have only one sheet with the combination of Project Types
and Types of Works. Am I correct?

Can you tell me more on setting up the sheets and the code to use?

Thanks.

"John Bundy" wrote:

You can give a specific list based on project type
if A is selected you could use list in column a and if B then list in column b

Range("e5").Validation _
.Modify xlValidateList, xlValidAlertStop, _
xlBetween, "=$A$1:$A$10"

-John

"AccessHelp" wrote:

Good morning,

In my Excel sheet, I have two fields: Project Type (B2) and Type of Work
(B4). Currently, I use Validation on both fields to have a drop-down for a
list of items. What I am hoping to do is, for example, if I select Project A
from the Project Type field, I only want Cell B4 to list the types of works
that apply to Project A, instead of listing entire list.

Can it be done?

Thanks.