i cant get validation from sheet one to sheet two why

R

Ravyoni

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

Gord Dibben

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

In that case, name the list range through Insert>Name>Define.

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


Gord Dibben MS Excel MVP
 
Top