 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Data List
I have a workbook with multiple sheets. I want to have all my Data Lists for drop down menus on their own seperate worksheet within that workbook. It says in Excel instructions that it can be done but when I try to do it I get a pop up that says I can't have my data in a seperate worksheet. Is there a way around this? Thanks for any light......... If you give that range a nice name, you can have it on another sheet. Debra Dalgleish shows how: http://www.contextures.com/xlDataVal01.html#Name > I have a workbook with multiple sheets. I want to have all my Data Lists for > drop down menus on their own seperate worksheet within that workbook. It > says in Excel instructions that it can be done but when I try to do it I get > a pop up that says I can't have my data in a seperate worksheet. Is there a > way around this? Thanks for any light.........  SignatureDave Peterson Sounds good but I did something wrong.... My worksheet is named "MPF" I have the "raw data" worksheet named "Data" where I want to keep my lists I created the dynamic lists on the "Data" worksheet and used the dynamic formula Whne I am on my "MPF" worksheet and goto data/validation/list and try to reference the list from the "Data" sheet - how do I do this? It won't let me select the "Data" worksheet. Thank you for your help on this...it is much appreciated. SignatureStompS Portland, OR http://www.geocities.com/pdxinvestr/Stomps.html > If you give that range a nice name, you can have it on another sheet. > [quoted text clipped - 9 lines] >> a >> way around this? Thanks for any light......... Take a look at Debra's site to see how to name that list first. Then after you name the range, you can use that name in the Data|Validation dialog. > Sounds good but I did something wrong.... > [quoted text clipped - 29 lines] > > > > Dave Peterson SignatureDave Peterson Got it! Somehow I didn't understand that part. Thank you! > Take a look at Debra's site to see how to name that list first. > [quoted text clipped - 41 lines] >> > >> > Dave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.