Each January 1st, I start a new Workbook for my little business, and in
each of these workbooks, I have a compilation worksheet that I have
data from other worksheets that feed to it automatically.
My question is:
Is it possible to have a stand-alone Workbook that acts only as a
compilation of the yearly workbooks and have the data from each of
these yearly workbooks feed automatically into the new stand-alone
Workbook?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=566286

hi!

as far as i know
i've only heard abt stand alone PC!!!

..stand alone WORKBOOK???...

it's my pleasure to have the explanation..!!!!

-via135

lsmft Wrote:
Each January 1st, I start a new Workbook for my little business, and in
each of these workbooks, I have a compilation worksheet that I have
data from other worksheets that feed to it automatically.
My question is:
Is it possible to have a stand-alone Workbook that acts only as a
compilation of the yearly workbooks and have the data from each of
these yearly workbooks feed automatically into the new stand-alone
Workbook?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=566286

Please excuse my written language as it is a reflection of my speech.
"Stand alone workbook" is only my way of saying a "workbook". My
intention is that it would be a separate workbook from my yearly
workbooks. It's all MS Excel, just different workbooks. I suppose it
would be easier to understand if I just asked if/how one could
automatically have data transferred from one workbook to another
workbook.
I've learned how to move data from one worksheet to another worksheet
within the same workbook, just can't see how to do it from one workbook
to another workbook.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=566286

The procedure for moving data between WSs is the same as moving data between
WBs,
The only difference being the path.

You can make XL do most of the work for you in creating this path (link).

Don't forget, in using functions, data can only be *pulled* from the source
WB.
The source WB cannot *push* data to the target WB.

Easiest is to open *both* WBs.

In the target WB, type an = sign in the cell to *pull* (link) a particular
cell of data.

Navigate to the source WB and click in the cell containing the data to
*pull*,
And hit <Enter.

You should now have the data from the source WB cell, displayed in the
target WB cell.

Look at the formula (link) XL created for you in this target cell.
You can now duplicate the path in this formula to create other links, or you
can follow the same procedure and allow XL to create these additional links
for you.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"lsmft" wrote in
message ...

Please excuse my written language as it is a reflection of my speech.
"Stand alone workbook" is only my way of saying a "workbook". My
intention is that it would be a separate workbook from my yearly
workbooks. It's all MS Excel, just different workbooks. I suppose it
would be easier to understand if I just asked if/how one could
automatically have data transferred from one workbook to another
workbook.
I've learned how to move data from one worksheet to another worksheet
within the same workbook, just can't see how to do it from one workbook
to another workbook.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=566286

Thank you for your reply, however it is not working for me. I must be
doing something wrong, just don't know what. I have created a target
workbook to act as a compilation of other workbooks. I clicked on a
target cell in a worksheet with an equal (=) sign, then went to the
workbook that I am pulling that data from, clicked on the desired cell
and all it did was advance to the next lower cell in the pull from
worksheet. I went back to the target workbook and it still showed an
equal (=) sign, as if I hadn't done anything else. ??????????????? What
now?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=566286

Sounds like you forgot to hit the <ENTER as instructed.

In the target WB, type an = sign in the cell to *pull* (link) a particular
cell of data.

Navigate to the source WB and click in the cell containing the data to
*pull*,
And hit <Enter.


Gord Dibben MS Excel MVP


On Sat, 29 Jul 2006 19:23:47 -0400, lsmft
wrote:


Thank you for your reply, however it is not working for me. I must be
doing something wrong, just don't know what. I have created a target
workbook to act as a compilation of other workbooks. I clicked on a
target cell in a worksheet with an equal (=) sign, then went to the
workbook that I am pulling that data from, clicked on the desired cell
and all it did was advance to the next lower cell in the pull from
worksheet. I went back to the target workbook and it still showed an
equal (=) sign, as if I hadn't done anything else. ??????????????? What
now?