MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.