Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
Can I pull sum from one workbook into another?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
Yes. More details, perhaps?
"Bernadette" wrote: Can I pull sum from one workbook into another? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)
If this post helps click Yes --------------- Jacob Skaria "Bernadette" wrote: Can I pull sum from one workbook into another? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
Yes
-- David Biddulph "Bernadette" wrote in message ... Can I pull sum from one workbook into another? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
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. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Yes -- David Biddulph "Bernadette" wrote in message ... Can I pull sum from one workbook into another? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
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? "Sean Timmons" wrote: Yes. More details, perhaps? "Bernadette" wrote: Can I pull sum from one workbook into another? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
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" wrote: =SUM('[Workbook.xls]Sheetname'!$C$2:$C$6) If this post helps click Yes --------------- Jacob Skaria "Bernadette" wrote: Can I pull sum from one workbook into another? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
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" wrote: 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" wrote: =SUM('[Workbook.xls]Sheetname'!$C$2:$C$6) If this post helps click Yes --------------- Jacob Skaria "Bernadette" wrote: Can I pull sum from one workbook into another? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull sum from one workbook into another?
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 On Wed, 21 Oct 2009 12:55:02 -0700, Bernadette wrote: 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" wrote: =SUM('[Workbook.xls]Sheetname'!$C$2:$C$6) If this post helps click Yes --------------- Jacob Skaria "Bernadette" wrote: Can I pull sum from one workbook into another? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to pull the rightmost, non-zero cell value in a workbook? | Excel Discussion (Misc queries) | |||
pull excess of 65,500 into a workbook | Excel Discussion (Misc queries) | |||
Question regarding using pull down menus inside an Excel workbook. | Excel Discussion (Misc queries) | |||
UDF alternative to PULL that opens external workbook and grabs val | Excel Worksheet Functions | |||
How do I pull a merged cell from another workbook? | Excel Worksheet Functions |