I am trying to create a dependent responing list to another drop down list in
excel.
I.e.
Drop down list 1:
1
2
3
Drop Down list 2:
A
B
C
If I selected 2 from the fist list I would want list two to automatically
register B.
I am trying to create a dependent responing list to another drop down list in
excel.
I.e.
Drop down list 1:
1
2
3
Drop Down list 2:
A
B
C
If I selected 2 from the fist list I would want list two to automatically
register B.
Try Deb's solution here:
http://www.contextures.com/xlDataVal02.html
These are called "cascading" or "dependent" drop-downs.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"elevenphil" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create a dependent responing list to another drop down list
>in
> excel.
>
> I.e.
> Drop down list 1:
> 1
> 2
> 3
>
> Drop Down list 2:
> A
> B
> C
>
> If I selected 2 from the fist list I would want list two to automatically
> register B.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks