Home |
Search |
Today's Posts |
#1
|
|||
|
|||
validation
I want to do a validastion from a list. but the list is in an other sheet.
Excel don`t let me do this. Is this a limitation of excel?? Regards in advance |
#2
|
|||
|
|||
Name the list under insertnamedefine and then refer to the name i.e.
datavalidationlist and in source box put =MyList Regards, Peo Sjoblom "qwerty" wrote in message ... I want to do a validastion from a list. but the list is in an other sheet. Excel don`t let me do this. Is this a limitation of excel?? Regards in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TWO QUESTIONS: Validation & Spacing...PLEASE HELP | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Validation Box all in same places | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |