Nothing or an error mesage that you can't use lists from other sheets?

In that case, name the list range through InsertNameDefine.

Then for DV list source enter =MyList where MyList is the name you gave the
range.


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 18:05:01 -0800, Ravyoni
wrote:

i have created lists in sheet 1 and tried to validate it in sheet 2 but
nothing happens when i request data validation