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.

--
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