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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a drop-down list from a range of cells 2
Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
Create a drop-down list from a range of cell 4
Drop Down with dynamic named range offsheet source list 14
extend the range of cells for a drop down list 8
Drop down list selections creating values in adjoining cell 1
Displaying drop down list arrows 2

Back
Top