| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
and another thing....DROP DOWN LISTS
For some reason I have to have my data I am using for my drop down lists on
the same worksheet as the analysis I am doing. Before I could have the data on a seperate worksheet within the same file. Any suggestions as why this is happening and more importantly how to fix it? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
and another thing....DROP DOWN LISTS
Leisl wrote: For some reason I have to have my data I am using for my drop down lists on the same worksheet as the analysis I am doing. Before I could have the data on a seperate worksheet within the same file. Any suggestions as why this is happening and more importantly how to fix it? Thank you. If your data list is a named range it can be on any sheet. Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
and another thing....DROP DOWN LISTS
See this example Leisl
http://www.contextures.com/xlDataVal01.html#Name -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Leisl" wrote in message ... For some reason I have to have my data I am using for my drop down lists on the same worksheet as the analysis I am doing. Before I could have the data on a seperate worksheet within the same file. Any suggestions as why this is happening and more importantly how to fix it? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
