Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference. SO, if I alter the individual
ones, I want the changes to pop up on the single Quick reference of everyone.
Make sense? THANKS!!!

Not really - sounds like you are working backwards.

You should maintain a central database/master list and then use extracts
from that for specific subsets.

--
Regards,
Tom Ogilvy


"bodhisatvaofboogie" wrote:

Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference. SO, if I alter the individual
ones, I want the changes to pop up on the single Quick reference of everyone.
Make sense? THANKS!!!

Yeah that makes sense....but alas, it can't be done. Actually it was a
question a coworker of mine had for me. I didn't know the answer so I
thought I would shoot it out here. I suggested he do everything in one file
with multiple worksheets. I know information can be shared that way. But he
didn't like the idea of that. *shrugs* Thanks for the input :)


"Tom Ogilvy" wrote:

Not really - sounds like you are working backwards.

You should maintain a central database/master list and then use extracts
from that for specific subsets.

--
Regards,
Tom Ogilvy


"bodhisatvaofboogie" wrote:

Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference. SO, if I alter the individual
ones, I want the changes to pop up on the single Quick reference of everyone.
Make sense? THANKS!!!

actually interestingly enough, there is a way to link two different
documents. I just accidentially stumbled upon it. Here's an example:

=SUM([Book1.xls]Sheet1!$A$7,[Book1.xls]Sheet1!$A$8)

Book1 is the Source file, and Book2 is the destination file. Place this
formula in any cell on Book2, and it will sum the two cells in Book1
effectively placing that value in that cell of Book2. So take any formula
and add [wkbook.name]Sheet#$r$c for formulas and it will factor that in.




"Tom Ogilvy" wrote:

Not really - sounds like you are working backwards.

You should maintain a central database/master list and then use extracts
from that for specific subsets.

--
Regards,
Tom Ogilvy


"bodhisatvaofboogie" wrote:

Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference. SO, if I alter the individual
ones, I want the changes to pop up on the single Quick reference of everyone.
Make sense? THANKS!!!

So the rows in the individual workbooks never change - just the values in
that row?

If that isn't the case, I don't see any value in what you suggest.

If you are just looking to summarize the data from the other workbooks, then
perhaps that is a viable option - but make sure all workbooks are open if you
make a change such as inserting rows.

--
Regards,
Tom Ogilvy


"bodhisatvaofboogie" wrote:

actually interestingly enough, there is a way to link two different
documents. I just accidentially stumbled upon it. Here's an example:

=SUM([Book1.xls]Sheet1!$A$7,[Book1.xls]Sheet1!$A$8)

Book1 is the Source file, and Book2 is the destination file. Place this
formula in any cell on Book2, and it will sum the two cells in Book1
effectively placing that value in that cell of Book2. So take any formula
and add [wkbook.name]Sheet#$r$c for formulas and it will factor that in.




"Tom Ogilvy" wrote:

Not really - sounds like you are working backwards.

You should maintain a central database/master list and then use extracts
from that for specific subsets.

--
Regards,
Tom Ogilvy


"bodhisatvaofboogie" wrote:

Is there a way to set up multiple different excel document files such that
altering one will effect various parts of another different excel document???
I have a system of sheets for individual clients, and the information on
those feeds the main one for quick reference. SO, if I alter the individual
ones, I want the changes to pop up on the single Quick reference of everyone.
Make sense? THANKS!!!