Read data from other worksheets
Posted by Mindy on June 22, 2001 6:23 AM
The is Excel 97 SR-2 file. I have a workbook contains multiple worksheets.
For example, in the worksheet1, I have a colume 'A1' with the formula of sum(A12:Z12).
Now in the worksheet2, I would like to have the link data of 'A1' from worksheet1.
In the worksheet2 on the colume I am going to link the data, I type =Sheet1!A1 .
I get the data back on the sheet2 of 0 instead of summary data from the sheet1.
Anyone has any idea of what i did wrong here?
Thank you very much for helping
Posted by Damon Ostrander on June 22, 2001 8:51 AM
Hi Mindy,
If you have renamed the worksheets "worksheet1" and "worksheet2" as you imply, then to refer to a cell on these sheets you would need to use the new sheet name (the "tab" name), i.e.,
=worksheet1!A1
Happy computing.
Damon
Posted by Mindy on June 22, 2001 8:58 AM
Hi Damon,
Thank you for the suggestion. I had rename it.
And I am still have problem to read the correct data.
ex:
name column column formula(if any) value
worksheet1 A2 =sum(A3:A20) 100
now I would like to have to value display
in the worksheet2 in the column B1.
on worksheets2, column B1 I type the fomula of
=worksheet1!A2
the return value in worksheet2!B1 is 0 instead of 100
Anything else I have to check or the formula has to be changed.
Thank you very much for helping.
