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
worksheet1 and display in cell B2,2 of worksheet2.
 

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