Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation
how can i use data validation for sheet1 to other sheet
sheet2. ****al |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation
"****al" wrote in message
... how can i use data validation for sheet1 to other sheet sheet2. Hi ****al, If you mean you want to create a data validation list on one sheet that points to a range on another sheet, give the list a book-level range name (highlight the list and type a name into the box directly to the left of the formula bar). Then you can enter =MyList (or whatever you named it) into the Source entry in the data validation dialog. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |