Data Valid - refers to the values of 2 cells
You cannot use a union as the source of a list, so I would simply reference both cells somewhere
else, say =F4 in cell F100 and =D6 in cell F101 and then use F100:F101 as the DV list source. You
can then copy those cells across the sheet as needed.
--
HTH,
Bernie
MS Excel MVP
"ash3154" wrote in message
...
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.
|