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 <atyahoo<dotcom
----
Sandy wrote in message
...
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