ello
Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create a
drop down for C3 that includes the same drop down from book1 but not limit
the entry to the existing list. ie., a list that is more extensive
How can I do this?
Thanks
ello
Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create a
drop down for C3 that includes the same drop down from book1 but not limit
the entry to the existing list. ie., a list that is more extensive
How can I do this?
Thanks
Not sure .. but maybe an illustration would help a bit?
Try this experiment:
In Sheet3:
Put in A1: Text1
Copy A1 down to A10
This rapidly creates a list of 10 items: Text1, Text2 ... Text10
for use as data validation (DV) source
Select and name the range A1:A5 as : List1
To name, just select the range,
then click inside the namebox* and type: List1
*the one with the droparrow just to the left of the equal sign "="
Likewise, select and name the range A1:A10 as : List2
In Sheet1:
Select A1
Click Data > Validation
Under Allow, select List
Put in the Source box: =List1
Click OK
A1 will now house a DV with Text1, Text2 ... Text5
In Sheet2:
Select C3
Click Data > Validation
Under Allow, select List
Put in the Source box: =List2
Click OK
C3 will now house a DV with Text1, Text2 ... Text10
i.e. a more "extensive" list of items compared with Sheet1's A1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Sandy <[email protected]> wrote in message
news:[email protected]...
> ello
> Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create
a
> drop down for C3 that includes the same drop down from book1 but not limit
> the entry to the existing list. ie., a list that is more extensive
> How can I do this?
> Thanks
Thanks Max
That helps some. However the lists are maintained separately in separate
workbooks. For now I have linked the first part of the long list to the
short list and am using the lists separately for each sheet. Not sure if
the most efficient way but I think it will work
Thanks again!
"Max" wrote:
> Not sure .. but maybe an illustration would help a bit?
>
> Try this experiment:
>
> In Sheet3:
>
> Put in A1: Text1
>
> Copy A1 down to A10
>
> This rapidly creates a list of 10 items: Text1, Text2 ... Text10
> for use as data validation (DV) source
>
> Select and name the range A1:A5 as : List1
>
> To name, just select the range,
> then click inside the namebox* and type: List1
>
> *the one with the droparrow just to the left of the equal sign "="
>
> Likewise, select and name the range A1:A10 as : List2
>
> In Sheet1:
>
> Select A1
> Click Data > Validation
> Under Allow, select List
> Put in the Source box: =List1
> Click OK
>
> A1 will now house a DV with Text1, Text2 ... Text5
>
> In Sheet2:
>
> Select C3
> Click Data > Validation
> Under Allow, select List
> Put in the Source box: =List2
> Click OK
>
> C3 will now house a DV with Text1, Text2 ... Text10
> i.e. a more "extensive" list of items compared with Sheet1's A1
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> Sandy <[email protected]> wrote in message
> news:[email protected]...
> > ello
> > Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create
> a
> > drop down for C3 that includes the same drop down from book1 but not limit
> > the entry to the existing list. ie., a list that is more extensive
> > How can I do this?
> > Thanks
>
>
>
You're welcome, Sandy !
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Sandy" <[email protected]> wrote in message
news:[email protected]...
> Thanks Max
> That helps some. However the lists are maintained separately in separate
> workbooks. For now I have linked the first part of the long list to the
> short list and am using the lists separately for each sheet. Not sure if
> the most efficient way but I think it will work
>
> Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks