To use list source from another sheet you must name the source range.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlDataVal01.html#Name


Gord Dibben MS Excel MVP


On Thu, 14 Sep 2006 07:47:02 -0700, scratching head <scratching
wrote:

How can I get Data Validations working across different sheets in the
workbook i.e I want the validation in sheet 1 but use the data in sheet 2.