Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation,........how to use a list in another sheet | Excel Worksheet Functions | |||
List Validation Based on another sheet | Excel Discussion (Misc queries) | |||
Excel sheet validation | Excel Discussion (Misc queries) | |||
data validation works in one sheet but not another | New Users to Excel | |||
Data Validation fromanother sheet | Excel Discussion (Misc queries) |