"Create a drop-down list from a range of cells"

Dear

By using the help level I have created dropdown list in one work book. I
want to use the same list in another workbook by linking the same way
(insert, name, define, refersto .......) as explained in help level but it is
not working.

Please help me.

It can be done, but it needs a bit of work.

Normally, you would use a named range in the DV type. You still do that but
you cannot use the name in the second workbook. You need to create an
additional named range in the first workbook that refersto the name in the
second workbook, and use that in the DV.

As an example, A1:A10 on Sheet1 in Book2. Create a name called rngBook2 with
Refersto =Sheet1!A1:A10.

Then in Boook1, create another name called say rngBook1, refersto
=[Book2]Sheet1!rngBook2.

Use rngBook1 in the DV custome type in Book1.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"DILNAVAS" <DILNAVAS@discussions.microsoft.com> wrote in message
news:B0EDE23B-7601-4FED-B036-36277B583626@microsoft.com...
> Dear
>
> By using the help level I have created dropdown list in one work book. I
> want to use the same list in another workbook by linking the same way
> (insert, name, define, refersto .......) as explained in help level but it
is
> not working.
>
> Please help me.