how do I referance a data valuation cell from another worksheet

K

Ken C

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
 
R

Ron@Buy

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
 
R

Ron@Buy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top