How to refer valve/text in cell in another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could anyone suggest me about How to refer text/valve in cell A1,1 of worksheet1 and display in cell B2,2 of worksheet2.
 
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.
 

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

Similar Threads

How do I use the text content of a cell as a worksheet reference? 9
I need a cell to be blank. 4
Macro Copy Worksheet Name into worksheet A1 3
Comparing columns from 2 different worksheets. 1
link cell to open a worksheet 1
#REF! Error 5
DBSUM function but with function as criterion, not a range 3
Retuyrning a single entry when multiples of the same 3

Back
Top