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!

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!

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!

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!

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!

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!

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!