| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add sum of cell from another worksheet
I don't get an error with this code but it also doesn't pick up the content
of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
Is the workbook 2006Digital.xls closed when you try to do this? If it must
be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
Barb,
Thanks for replying so quickly. The work book will be closed. So I tried the MOREFUNC method you recommended but get a #NAME? error. Maybe the spaces in the path are messing it up? Here's what I put: =INDIRECT.EXT("'C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32")+July1!J29+July2!J29+Aug1!J29+Aug2!J29 +Sept1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+No v2!J29+Dec1!J29+Dec2!J29 Which is where the original file resides (2006Digital2.xls) "Barb Reinhardt" wrote: Is the workbook 2006Digital.xls closed when you try to do this? If it must be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
Try taking out the double quotes.
"drumz" wrote: Barb, Thanks for replying so quickly. The work book will be closed. So I tried the MOREFUNC method you recommended but get a #NAME? error. Maybe the spaces in the path are messing it up? Here's what I put: =INDIRECT.EXT("'C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32")+July1!J29+July2!J29+Aug1!J29+Aug2!J29 +Sept1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+No v2!J29+Dec1!J29+Dec2!J29 Which is where the original file resides (2006Digital2.xls) "Barb Reinhardt" wrote: Is the workbook 2006Digital.xls closed when you try to do this? If it must be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
Also change
C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32 to C:\Documents and Settings\My Documents\Billing\B-Digital\[2006Digital.xls]June2'!L32 "drumz" wrote: Barb, Thanks for replying so quickly. The work book will be closed. So I tried the MOREFUNC method you recommended but get a #NAME? error. Maybe the spaces in the path are messing it up? Here's what I put: =INDIRECT.EXT("'C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32")+July1!J29+July2!J29+Aug1!J29+Aug2!J29 +Sept1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+No v2!J29+Dec1!J29+Dec2!J29 Which is where the original file resides (2006Digital2.xls) "Barb Reinhardt" wrote: Is the workbook 2006Digital.xls closed when you try to do this? If it must be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
Nothing works. I tried:=INDIRECT.EXT(C:\Documents and Settings\My
Documents\Billing\Digital\[2006Digital.xls]June2'!L32) AND =INDIRECT.EXT(C:\Documents and Settings\My Documents\Billing\Digital[2006Digital.xls]June2'!L32) BOTH produce an error in the formula Doing this: =INDIRECT.EXT("C:\Documents and Settings\My Documents\Billing\Digital\[2006Digital.xls]June2'!L32") OR =INDIRECT.EXT("C:\Documents and Settings\My Documents\Billing\Digital[2006Digital.xls]June2'!L32") BOTH produce the error #name? Sorry to be a pain but it doesn't make sense that it doesn't work even though I'm following the examples at: http://xcell05.free.fr/english/moref...direct.ext.htm I'm using Office 2003 . Thanks again for your help! "Barb Reinhardt" wrote: Also change C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32 to C:\Documents and Settings\My Documents\Billing\B-Digital\[2006Digital.xls]June2'!L32 "drumz" wrote: Barb, Thanks for replying so quickly. The work book will be closed. So I tried the MOREFUNC method you recommended but get a #NAME? error. Maybe the spaces in the path are messing it up? Here's what I put: =INDIRECT.EXT("'C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32")+July1!J29+July2!J29+Aug1!J29+Aug2!J29 +Sept1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+No v2!J29+Dec1!J29+Dec2!J29 Which is where the original file resides (2006Digital2.xls) "Barb Reinhardt" wrote: Is the workbook 2006Digital.xls closed when you try to do this? If it must be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add sum of cell from another worksheet
I had to download this at home to check it out. It seems the syntax may have
changed, but I've been known to be wrong. I got this formula to work on a closed workbook =INDIRECT.EXT("'C:\Documents and Settings\Barb Reinhardt\My Documents\[Furniture Calculations.xls]Sheet1'!$A$1") Make sure you have the add-in enabled. "drumz" wrote: Nothing works. I tried:=INDIRECT.EXT(C:\Documents and Settings\My Documents\Billing\Digital\[2006Digital.xls]June2'!L32) AND =INDIRECT.EXT(C:\Documents and Settings\My Documents\Billing\Digital[2006Digital.xls]June2'!L32) BOTH produce an error in the formula Doing this: =INDIRECT.EXT("C:\Documents and Settings\My Documents\Billing\Digital\[2006Digital.xls]June2'!L32") OR =INDIRECT.EXT("C:\Documents and Settings\My Documents\Billing\Digital[2006Digital.xls]June2'!L32") BOTH produce the error #name? Sorry to be a pain but it doesn't make sense that it doesn't work even though I'm following the examples at: http://xcell05.free.fr/english/moref...direct.ext.htm I'm using Office 2003 . Thanks again for your help! "Barb Reinhardt" wrote: Also change C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32 to C:\Documents and Settings\My Documents\Billing\B-Digital\[2006Digital.xls]June2'!L32 "drumz" wrote: Barb, Thanks for replying so quickly. The work book will be closed. So I tried the MOREFUNC method you recommended but get a #NAME? error. Maybe the spaces in the path are messing it up? Here's what I put: =INDIRECT.EXT("'C:\Documents and Settings\My Documents\Billing\B-Digital[2006Digital.xls]June2'!L32")+July1!J29+July2!J29+Aug1!J29+Aug2!J29 +Sept1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+No v2!J29+Dec1!J29+Dec2!J29 Which is where the original file resides (2006Digital2.xls) "Barb Reinhardt" wrote: Is the workbook 2006Digital.xls closed when you try to do this? If it must be closed, there is a function that you could use to get data from a closed workbook. It's called INDIRECT.EXT and it's in an addin call MOREFUNC. Do a google search and you should find it. "drumz" wrote: I don't get an error with this code but it also doesn't pick up the content of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Linear Mode
