View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken C[_2_] Ken C[_2_] is offline
external usenet poster
 
Posts: 17
Default how do I referance a data valuation cell from another worksheet

I have a problem where I want to referance a cell that is using data
valuation to get one of 4 results and bring the results to another worksheet.
I've tried to link the worksheets but I don't get the information. The
worksheet 1 cell d19 refers to one of 4 inputs range $g$1:$g$4, I want to be
able to pull that information over to another worksheet called calculations,
The same cell as worksheet 1 (D19) is the same as the calculations worksheet
(D19). Any help would be greatly appreciated

Ken