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
|