View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default how do I referance a data valuation cell from another worksheet

Ken this isn't the most dynamic solution but try this:
Worksheet 1 in any cell (lets say C19) enter =D19
worksheet Calculations in cell D19 enter =C19
I expect somebody else will come up with a better solution

"Ken C" wrote:

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