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

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

how do I referance a data valuation cell from another workshee
 

Whoops! sorry
Should be:
worksheet Calculations in cell D19 enter ='worksheet 1'!C19



"Ron@Buy" wrote:

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