View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ash3154 ash3154 is offline
external usenet poster
 
Posts: 23
Default Data Valid - refers to the values of 2 cells

How would I insert in my input box of data validation the values of cells D6
and F4

basically if the user clicks on a cell F6 I want it to reference f4 and d6
if they are in cell f8 I would like it to reference f4 and d8
if they are in cell ax106 I would like to refernece ax4 and d106... so on.