Data Validation - List

[Wayne]

Hi World

I'm using Excel 97

I have a cell that I want to select a value from a list.

The list that I want to select from is on a different
worksheet.
I've tried using Data Validation, selecting the Stettings
Tab and in the allow dialog box chossing select list.
But the source dialog will not let me choose any list
that is not on the same worksheet.

Anyone with a high IQ any ideas on how to achieve this?

 

[Arvi Laanemets]

Hi

With validation list, only cell references to same worksheet are allowed.
To refer to list on another worksheet in same workbook, you have to define
the list as named range (Insert.Name.Define...)
To refer to list in another workbook, the safest way will be mirroring it
into some sheet (links or ODBC query), define the mirrored list as named
range, and refer to named range as list source.

 

[Andy Brown]

The list that I want to select from is on a different

worksheet.

You need to define a name for the list, then refer to the name as the source
; similar to

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

Rgds,
Andy