View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JudithJubilee
 
Posts: n/a
Default How do I create a dropdown list using data from a different workbo

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!!