Automatic Feeding

[lsmft]

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]

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]

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.

 

[RagDyeR]

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!
=====================================================


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]

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

 

[Gord Dibben]

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

 

[Ragdyer]

I read it the *other* way Gord.

I think the OP typed an = sign, hit <Enter>, and then clicked back into that
cell, and then started to navigate.

To Ismft,

Type the equal sign into a cell -
*Then* start to navigate to the other WB.

*DON'T* do anything between keying in the = sign and clicking in the source
WBs cell.

 

[lsmft]

Thanks again!!!!
I did get it to work this time, but only by tileing the workbooks, for
whatever reason. I noticed on my "Compilation" Workbook that I lose the
ability to "click and drag" as I have been able to do when moving data
to a compilation worksheet within the same workbook. I can work around
that though, so thanks again.

 

[Ragdyer]

Glad you got it working ... BUT ... you *don't* have to "click and drag"!

Once more:

Click in the cell.
Type the equal sign.
Mouse cursor down to status bar and click on name of source WB.
Click in cell containing source data.
Hit <Enter>, and you're done!

Another way, since you say that you've tiled some of your WBs.

With *both* cells (source and target) visible on your screen:
Click in target cell,
type in = sign,
Click in source cell, and hit <Enter>.

*No* need to drag anything!