linking 2 sheets

Posted by tim on December 15, 2001 5:53 PM

I am in dire need of some Excel help.

My situation:

I have created two sheets, which I will call sheet1
and sheet2. I want cell "sheet2!d11" to display the
value from "sheet1!A37" using the range
"sheet2!A11:C11" in place of range "sheet1!A5:C5"

I would be very greatful for any suggestions.

Thanks

Posted by Jacob on December 15, 2001 6:17 PM

Im not 100% sure what you are looking for, but:

In Sheet2 D11 type =Sheet1!A37

That will display the value you want.

If you were looking for more or something different post some more info.

Jacob