Drop down list

  • Thread starter Thread starter gregmf68-posting
  • Start date Start date
G

gregmf68-posting

OK, I have a basic spreedsheet and I created a drop down list (yes, no
and NA) i did the data...> validation and linked it to the cells but i
can't figure out how to link it to cells on another sheet from the same
spreadsheet? when i go and choose my cells it won't let me hit the
other worksheet that i want to refer to? I am I doing this backwards?

here is what i have in data...validation...source field =$N$22:$N$26
TIA,
Greg
 
Greg,

Create the list of possible values in consecutive rows on the other sheet
and then use Insert Name Define to Name the range containing the list as
"MyList". Now go back to the other sheet and use data validation to create
the drop down box, using list as before, and make entry "=MyList".

Good Luck,

Frank
 
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

Data Validation List (conditional) 2
Pick from drop-down list gives empty or erroneous result 6
Drop Down List Format 2
Drop Down Lists 2
Data Validation Drop Down Using VBA? 1
Link Drop Down list with Pivot Table 3
Data Validation drop down list query 3
Define the Range of a drop-down list 5

Back
Top