How to refer valve/text in cell in another worksheet

C

chanon

Could anyone suggest me about How to refer text/valve in cell A1,1 of worksheet1 and display in cell B2,2 of worksheet2.
 
K

Kevin Stecyk

Chanon,

Go to B2 of Worksheet2, hit the equals sign, and then select A1 of worksheet
one.

Or alternatively, in B2 of Worksheet2, go "=Sheet1!A1" without the quotation
marks.

Regards,
Kevin

chanon said:
Could anyone suggest me about How to refer text/valve in cell A1,1 of
Click to expand...
worksheet1 and display in cell B2,2 of worksheet2.
 
Top