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.

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

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.