Data Validation - Conditional List

[Scott]

I have two drop down windows and I want the list of values available in drop
down two to be dependent on the selection from the first drop down.

Example:
Drop down #1 - Department
1. Accounting
2. HR
3. Marketing

Drop down #2 - Projects to Charge
1. Accounting can charge projects: 1,2,3
2. HR can charge projects: 2, 3, 4, and 5
3. Marketing can charge projects: 6, 7, and 8

How can I populate my list for the second drop down based on the selection
from the first drop down? For example, if someone selects HR for the 1st drop
down, how do I make my 2nd drop down list to show projects 2, 3, 4, and 5.

Thanks,
Scott

 

[Yegod]

Are these data validation dropdowns?

 

[darkblue]

I'd strongly suggest you to have a visit below address.
( Category D : Data validation )

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

 

[Chip Pearson]

Scott,

Suppose your first validation cell (for Department) is cell B5. In
some region of the worksheet, create a table like the following:

Accounting one two three
Human Res two three four five
Marketing six seven eight

In this example, we'll assume that this group of cells is in G22:K24.

Select B5, open Data Validation, choose List from the Allow list and
enter

=$G$22:$G$24

as the Source for the list. This limits the user's selection to
Accounting, Human Res, and Marketing.

Suppose that the next validation cell, from which the project is to be
selected, is cell B6. Select cell B6 and open Data Validation. Choose
List from the Allow list and enter

=OFFSET($G$22,MATCH($B$5,$G$22:$G$24,0)-1,1,1,COUNTA(G22:Z22))

as the Source for the list.

With these validation rules in effect, the B5 dropdown will display
the three departments, and the projects allowed for that department
will be displayed in the B6 dropdown. The content of the list for B6
changes depending upon what it selected in B5.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]