How do I create a dropdown list using data from a different workbo

I'm using Excel 2003, and have used the on-line help, have followed the
instructions clearly. Yet at the end of it all Excel states that I'm unable
to use validation against data from other workbooks, yet I have followed the
instructions under the online help: Create a drop-down list from a range of
cells. I can create a drop-down list using data from the same worksheet,
HELP!!

Hello VFPguruExcelNovice,

Try this step-by-step tutorial:

http://www.contextures.com/xlDataVal05.html

I have 2003 and follow this works for me.

Post back if you are still having difficulties!

Judith

--
Hope this helps


"VFPguruExcelNovice" wrote:

> I'm using Excel 2003, and have used the on-line help, have followed the
> instructions clearly. Yet at the end of it all Excel states that I'm unable
> to use validation against data from other workbooks, yet I have followed the
> instructions under the online help: Create a drop-down list from a range of
> cells. I can create a drop-down list using data from the same worksheet,
> HELP!!

If the data is on another worksheet in the same workbook, you have to give
the target range a name (Insert>Name>Define...) and use that. In another
workbook, not possible I think.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JudithJubilee" <[email protected]> wrote in message
news:[email protected]...
> Hello VFPguruExcelNovice,
>
> Try this step-by-step tutorial:
>
> http://www.contextures.com/xlDataVal05.html
>
> I have 2003 and follow this works for me.
>
> Post back if you are still having difficulties!
>
> Judith
>
> --
> Hope this helps
>
>
> "VFPguruExcelNovice" wrote:
>
> > I'm using Excel 2003, and have used the on-line help, have followed the
> > instructions clearly. Yet at the end of it all Excel states that I'm
unable
> > to use validation against data from other workbooks, yet I have followed
the
> > instructions under the online help: Create a drop-down list from a range
of
> > cells. I can create a drop-down list using data from the same worksheet,
> > HELP!!

Thankyou!

"VFPguruExcelNovice" wrote:

> I'm using Excel 2003, and have used the on-line help, have followed the
> instructions clearly. Yet at the end of it all Excel states that I'm unable
> to use validation against data from other workbooks, yet I have followed the
> instructions under the online help: Create a drop-down list from a range of
> cells. I can create a drop-down list using data from the same worksheet,
> HELP!!

>In another workbook, not possible I think.

Possible, but not worth the trouble.

You'd have to create the defined name in the target file and the source file
has to open.

Easier just to create the source in the current file.

Biff

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> If the data is on another worksheet in the same workbook, you have to give
> the target range a name (Insert>Name>Define...) and use that. In another
> workbook, not possible I think.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "JudithJubilee" <[email protected]> wrote in message
> news:[email protected]...
>> Hello VFPguruExcelNovice,
>>
>> Try this step-by-step tutorial:
>>
>> http://www.contextures.com/xlDataVal05.html
>>
>> I have 2003 and follow this works for me.
>>
>> Post back if you are still having difficulties!
>>
>> Judith
>>
>> --
>> Hope this helps
>>
>>
>> "VFPguruExcelNovice" wrote:
>>
>> > I'm using Excel 2003, and have used the on-line help, have followed the
>> > instructions clearly. Yet at the end of it all Excel states that I'm
> unable
>> > to use validation against data from other workbooks, yet I have
>> > followed
> the
>> > instructions under the online help: Create a drop-down list from a
>> > range
> of
>> > cells. I can create a drop-down list using data from the same
>> > worksheet,
>> > HELP!!
>
>