Connecting multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

Just use the = sign and then reference to the other
workbooks by pointing to the appropriate cell that is to
be linked.
 
You must log in or register to reply here.

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

connecting multiple work sheets 1
Advantages and disadvantages of individual file based compression and inter-file compression 1
Insert multiple .dat files into one pdf without losing color of their graphs 0
Linking data from worksheet to worksheet 6
link to sheets 2
Combing Info. from multiple worksheets 2
multiple csv files into individual tabs 3
How do I lookup data from multiple worksheets? 2

Back
Top