--
Thanks for your help in advance.
--
Thanks for your help in advance.
You can create dependent data validation lists. There are instructions
here:
http://www.contextures.com/xlDataVal02.html
fdebelo wrote:
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
I have a drop down list in A3 with 2 items in the list. If i select the item
1 from A3 list, I would like to open the drop down list in A4, and see the
list associated with item 1 in A3.
If I select item 2 in A3, the list in A4 would be a different list, one that
is associated with A3. is this possible without utilizing access?
--
Thanks for your help in advance.
"fdebelo" wrote:
>
> --
> Thanks for your help in advance.
In a simple example as you give, all you need is something like this formula
in your second DV, type of list
=if(F1=1,m1:M4,N1:N4)
better still use named ranges.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"fdebelo" <fdebelo@discussions.microsoft.com> wrote in message
news:B648B679-9A92-4FFD-A46F-DDBCFE29AA5F@microsoft.com...
> I have a drop down list in A3 with 2 items in the list. If i select the
item
> 1 from A3 list, I would like to open the drop down list in A4, and see the
> list associated with item 1 in A3.
>
> If I select item 2 in A3, the list in A4 would be a different list, one
that
> is associated with A3. is this possible without utilizing access?
> --
> Thanks for your help in advance.
>
>
> "fdebelo" wrote:
>
> >
> > --
> > Thanks for your help in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks