Thread: Validation List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AFJr AFJr is offline
external usenet poster
 
Posts: 20
Default Validation List

Hi,

I have a dropdown from a validation list. I want to reference the cell that
the list is pointing to.

Ex. my list where the dropdown is located is E71, the list is located at
AC69 and is 23 rows. When an item is selected from the list, I want to
reference the cell in the list (AC69-AC91) not E71.
--
TIA

AFJr