Link Drop Down Boxes in Excel - HELP Please
 

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

Link Drop Down Boxes in Excel - HELP Please
 

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.

--
regards,
Tom Ogilvy


wrote in message
oups.com...
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