Link Drop Down Boxes in Excel - HELP Please

  • Thread starter Thread starter conorfinnegan
  • Start date Start date
C

conorfinnegan

I have created an Validation List drop down box that is used to
populate the data in one sheet. In another sheet, I have the data
from the first sheet sorted to show the top 25 matching values. What
I would like is to have that validation drop down box selectable from
either sheet. In other words, I would like to be able to select the
drop down values from either sheet I am in since the data shown in the
second sheet is dependent on the first. Is this even possible?

Thanks for the help anyone can provide.

Conor
 
Here is a guess at what you want:

Insert=>Name=>Define

Name: List1
Refers To: =Sheet2!$A$1:$A$25


Click Add.

Then in your data validation dialog, in the source textbox put =List1

The equal sign is important.

This allows the validation list to refer to an list on another sheet or the
same sheet.
 

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

Drop down boxes in VBA 1
Drop down list - link to another worksheet 4
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
lookup drop down 1
Drop Down Box 7
Drop Down with hidden values 1
EXCEL DROP DOWN 2

Back
Top