creating a drop down box using names from a different workbook

[remarkable]

I want to create a drop down box using a names list I have saved in a
different workbook? Please help me in laymans terms please!!

 

[Jacob Skaria]

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes

 

[remarkable]

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes

Thanks Jacob, but I am getting an error message tell me that "the formula I
have typed contains an error". Please tell me what I am doing wrong????
Thanks Michelle.

 

[Fred Smith]

"Book2", "Sheet1" and "a1:a10" are only examples. As you didn't tell us the
names of your workbooks or worksheets, we can only post examples of how to
do it. You need to change these sample names to the ones you are actually
using.

If this is too difficult for you, post the names you use, so that responders
can reply with the formula appropriate for you.

Regards,
Fred.

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes

Thanks Jacob, but I am getting an error message tell me that "the formula
I
have typed contains an error". Please tell me what I am doing wrong????
Thanks Michelle.

 

[OssieMac]

XL2002 returns an error message "You may not use references to other
worksheets or Workbooks for Data Validation criteria"

XL2003 I can't test.

XL2007 works but if you have an spaces in the workbook or sheet name then
you need single quotes around them like this:-

='[Validation List.xlsm]Sheet 1'!$A$1:$A$10

Note carefully the position of the single quotes also that .xlsm extension
is also required.

If using an earlier version of xl where the validation does not work with
another workbook then you can try using a combo box from the Forms Tool Bar
(Easier to set up than the Combo Box on the Control Tool Box tool bar).

--
Regards,

OssieMac

"Book2", "Sheet1" and "a1:a10" are only examples. As you didn't tell us the
names of your workbooks or worksheets, we can only post examples of how to
do it. You need to change these sample names to the ones you are actually
using.

If this is too difficult for you, post the names you use, so that responders
can reply with the formula appropriate for you.

Regards,
Fred.

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes

Thanks Jacob, but I am getting an error message tell me that "the formula
I
have typed contains an error". Please tell me what I am doing wrong????
Thanks Michelle.

 

[Gord Dibben]

First define a name for the source range in the source workbook.

Then use that name in the destination workbook.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal05.html


Gord Dibben MS Excel MVP

 

[remarkable]

Hi Fred, I did gather that and did change it?!?!?!?! Thanks.

"Book2", "Sheet1" and "a1:a10" are only examples. As you didn't tell us the
names of your workbooks or worksheets, we can only post examples of how to
do it. You need to change these sample names to the ones you are actually
using.

If this is too difficult for you, post the names you use, so that responders
can reply with the formula appropriate for you.

Regards,
Fred.

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes

Thanks Jacob, but I am getting an error message tell me that "the formula
I
have typed contains an error". Please tell me what I am doing wrong????
Thanks Michelle.

 

[remarkable]

Thanks OssieMac, but I got this message
"You cannot use references to other worksheets or workbooks for Data
Validation criteria" and i'm using Excel2007. What do you think I am doing
wrong?????

XL2002 returns an error message "You may not use references to other
worksheets or Workbooks for Data Validation criteria"

XL2003 I can't test.

XL2007 works but if you have an spaces in the workbook or sheet name then
you need single quotes around them like this:-

='[Validation List.xlsm]Sheet 1'!$A$1:$A$10

Note carefully the position of the single quotes also that .xlsm extension
is also required.

If using an earlier version of xl where the validation does not work with
another workbook then you can try using a combo box from the Forms Tool Bar
(Easier to set up than the Combo Box on the Control Tool Box tool bar).

--
Regards,

OssieMac

"Book2", "Sheet1" and "a1:a10" are only examples. As you didn't tell us the
names of your workbooks or worksheets, we can only post examples of how to
do it. You need to change these sample names to the ones you are actually
using.

If this is too difficult for you, post the names you use, so that responders
can reply with the formula appropriate for you.

Regards,
Fred.

:

Hi

You can refer to a range in Book2 from Book1.
In data validation source..

=[Book2]Sheet1!$A$1:$A$10


If this post helps click Yes
--------------
Jacob Skaria

Thanks Jacob, but I am getting an error message tell me that "the formula
I
have typed contains an error". Please tell me what I am doing wrong????
Thanks Michelle.

 

[John]

I'm having the same issue, I've tried following Debra's solution and the
EXCEL help file solution - but without sucess.

Did anyone in this thread actually get this to work?