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