Data List

  • Thread starter Thread starter StompS
  • Start date Start date
S

StompS

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.........
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Move or Copy Stopped Working? 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Convert from excel to word - can this be done? 1
data validation list 17
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Restrict Choice in Shared WB (drop down alternative)? 0
Selective data validation list 1

Back
Top