Add sum of cell from another worksheet

G

Guest

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+Sept1!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!
 
G

Guest

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.
 
G

Guest

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+Nov2!J29+Dec1!J29+Dec2!J29
Which is where the original file resides (2006Digital2.xls)

Barb Reinhardt said:
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 said:
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+Sept1!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!
Click to expand...
Click to expand...
 
G

Guest

Try taking out the double quotes.

drumz said:
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+Nov2!J29+Dec1!J29+Dec2!J29
Which is where the original file resides (2006Digital2.xls)

Barb Reinhardt said:
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 said:
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+Sept1!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!
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

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 said:
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+Nov2!J29+Dec1!J29+Dec2!J29
Which is where the original file resides (2006Digital2.xls)

Barb Reinhardt said:
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 said:
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+Sept1!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!
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

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/morefunc/indirect.ext.htm

I'm using Office 2003 .
Thanks again for your help!

Barb Reinhardt said:
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 said:
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+Nov2!J29+Dec1!J29+Dec2!J29
Which is where the original file resides (2006Digital2.xls)

Barb Reinhardt said:
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.

:

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+Sept1!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!
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

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 said:
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/morefunc/indirect.ext.htm

I'm using Office 2003 .
Thanks again for your help!

Barb Reinhardt said:
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 said:
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+Nov2!J29+Dec1!J29+Dec2!J29
Which is where the original file resides (2006Digital2.xls)

:

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.

:

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+Sept1!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!
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

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.

Ask a Question

Similar Threads

Importing Information in Table Through SQL 3

Top