If you want to know HOW, click in your destination cell, type the = sign, go
to your source sheet, click in the source cell.
The formula will show something like =[Book1]Sheet4!$A$1
Enter to accept that formula.
I have two seperate spreadsheets. Spreadsheet A has a summary page that I
would like to have include a total that is located on spreadsheet B. Can it
be done and do you know how to do that?
I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?
Jacob Skaria said:
=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)
If this post helps click Yes
---------------
Jacob Skaria
Did you include the ' and the [ as needed? It would be best to type =SUM(
then highlight the desired range of cells to sum.
Bernadette said:
I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?
Jacob Skaria said:
=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)
If this post helps click Yes
---------------
Jacob Skaria
It would not work if you have your two workbooks open in separate instances
of Excel.
Close one instance and open both workbooks in a single instance of Excel.
Gord Dibben MS Excel MVP
I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?
Jacob Skaria said:
=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)
If this post helps click Yes
---------------
Jacob Skaria
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.