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
|