View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] conorfinnegan@gmail.com is offline
external usenet poster
 
Posts: 28
Default 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