Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DILNAVAS
 
Posts: n/a
Default "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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default "Create a drop-down list from a range of cells"

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" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down List + VLOOKUP Bonbon Excel Worksheet Functions 1 March 12th 06 05:42 PM
Drop down list limit to list Dropdown3 Excel Discussion (Misc queries) 4 March 3rd 06 10:54 PM
Input Range for a List Box sca723 Excel Worksheet Functions 1 November 11th 05 04:15 PM
input range in drop down list Otto Excel Discussion (Misc queries) 3 July 27th 05 09:09 PM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"