Prev: How to make "X" have the value of 1?
Next: how do i format sub sections in a pivot table
From: Scott on 10 May 2010 15:37
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


From: Yegod on 10 May 2010 15:59
Are these data validation dropdowns?

"Scott" wrote:

> 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
>
>
From: darkblue on 10 May 2010 16:51

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

http://www.contextures.com/tiptech.html
From: Chip Pearson on 10 May 2010 17:03
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]





On Mon, 10 May 2010 12:37:01 -0700, Scott
<Scott(a)discussions.microsoft.com> wrote:

>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
>
 | 
Pages: 1
Prev: How to make "X" have the value of 1?
Next: how do i format sub sections in a pivot table