Excel 07 / Data Validation / List /

  • Thread starter Thread starter WSR
  • Start date Start date
W

WSR

When I want to use a list from a separate tab in Excel for drop down choices
I'm not able to Ctrl / Page Down to another tab in the excel workbook to
select the list choices. I have to manually type in the location of the data
in the "Source" box.

Am I doing anything wrong?
 
Name the list, say, "MyList".
When you setup the DV cell, in the source box, type "=MyList" without the
quotes. HTH Otto
 

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

Data Validation List Names 2
Data/Validate/List 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Created invoices in Excel - not working in Drive 1
Data Validation 1
Data Validation Lists 5
frustrated excel newbie 2
Drop Down Lists 2007 10

Back
Top