I have one worksheet (A) that calculates a specific value in a particular cell (call it cell R12) and the value of this cell is dependent on the value of a variable in another cell (say cell C1).

I want to use the value of cell R12 in another worksheet (B) but I need to send the value of C1 to worksheet A and get it to return the value of R12. So I need to find a function that does this Function ('worksheet B'C1=x, 'worksheet B'R12) i.e I send worksheet B the input variable and it returns the dependent variable.

Hope this makes sense.

Thx heaps