i cant get validation from sheet one to sheet two why
 

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

i cant get validation from sheet one to sheet two why
 

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