Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list
OK, I have a basic spreedsheet and I created a drop down list (yes, no
and NA) i did the data... validation and linked it to the cells but i can't figure out how to link it to cells on another sheet from the same spreadsheet? when i go and choose my cells it won't let me hit the other worksheet that i want to refer to? I am I doing this backwards? here is what i have in data...validation...source field =$N$22:$N$26 TIA, Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list
Hi
see: http://www.contextures.com/xlDataVal05.html Create a defined name for your source list and use this name in your data validation dialog as source -- Regards Frank Kabel Frankfurt, Germany wrote: OK, I have a basic spreedsheet and I created a drop down list (yes, no and NA) i did the data... validation and linked it to the cells but i can't figure out how to link it to cells on another sheet from the same spreadsheet? when i go and choose my cells it won't let me hit the other worksheet that i want to refer to? I am I doing this backwards? here is what i have in data...validation...source field =$N$22:$N$26 TIA, Greg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list
Greg,
Create the list of possible values in consecutive rows on the other sheet and then use Insert Name Define to Name the range containing the list as "MyList". Now go back to the other sheet and use data validation to create the drop down box, using list as before, and make entry "=MyList". Good Luck, Frank wrote in message ... OK, I have a basic spreedsheet and I created a drop down list (yes, no and NA) i did the data... validation and linked it to the cells but i can't figure out how to link it to cells on another sheet from the same spreadsheet? when i go and choose my cells it won't let me hit the other worksheet that i want to refer to? I am I doing this backwards? here is what i have in data...validation...source field =$N$22:$N$26 TIA, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |