I have sheet1 where
I input a value in cell A1 =(say 2)
After some calculations done in another cells using A1 value
finally cell A10 is the output value of the calculation.

I have another sheet2 in the same workbook
In column D , i.e D1, D2, D3 I input 2, 3, 4

I want in column E the output value of A10 of sheet1 for the
corresponding input of D1 for A1 (of sheet1).

How can write a macro for this.

Else the only way left out is

I manually substitue the value of D1 (of sheet2) in A1 (of sheet1) and
then copy the output value of A10 (of sheet1) to E1 (of sheet2)

Can anyone help in this regard.

simha Rupa Das

In A1 of Sheet1 put this formula:

=Sheet2!D1

In E10 of Sheet2 put this formula:

=Sheet1!A10

If you change what is in D1 in Sheet2 this will ripple through and
affect your value in E10.

Hope this helps.

Pete

On Jan 15, 5:28*am, " wrote:
I have sheet1 where
I input a value in cell A1 =(say *2)
After some calculations done in another cells using A1 value
finally cell A10 is the output value of the calculation.

I have another sheet2 in the same workbook
In column D , i.e D1, D2, D3 I input 2, 3, 4

I want in column E the output value of A10 of sheet1 for the
corresponding input of D1 for A1 (of sheet1).

How can write a macro for this.

Else the only way left out is

I manually substitue the value of D1 (of sheet2) in A1 (of sheet1) and
then copy the output value of A10 (of sheet1) to E1 (of sheet2)

Can anyone help in this regard.

simha Rupa Das