Connecting multiple worksheets

[fyon]

Hi there:
Can anyone please help me out here? Suppose I have many different files
(with detailed info) and I have one main summary file that draw results from
these individual files. How can I connect these individual files with the
main file? i.e, when I make changes in any one of the individual files, the
changes will reflect in the main file as well?

Any suggestions will be greatly appreciated!
Thanks..


fyon

[akk]

Hi

Just use the = sign and then reference to the other
workbooks by pointing to the appropriate cell that is to
be linked.

>-----Original Message-----
>Hi there:
> Can anyone please help me out here? Suppose I have
many different files
>(with detailed info) and I have one main summary file
that draw results from
>these individual files. How can I connect these
individual files with the
>main file? i.e, when I make changes in any one of the
individual files, the
>changes will reflect in the main file as well?
>
> Any suggestions will be greatly appreciated!
>Thanks..
>
>
>fyon
>.
>