Related Data Between 2 Different Workbooks

F

freeecoom

Hello everyone,
I need to create 2 workbooks, which have data relationships.

I don't know how to get data connect when I change data in the first
workbook, this data will also be automatically changed in the second
workbook.

Please give me a hand. Thank you very much and I am looking forward to
hearing from you.

Regards,
Peter
 
R

RagDyer

One way:

Open both WBs.
Click in a cell of the WB to *receive* the data.
Enter an equal sign,
=
Navigate to the WB to be copied (source), and click in the cell containing
the source data, and hit <Enter>.

You've just created a link, where you can copy the syntax into other cells,
or repeat the procedure and let XL create the links for you.

When you close the source WB, you'll see the formula increase in length to
display the full path to the other WB.
--
HTH,

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

freeecoom

Dear RagDyer,
Thank you very much for sharing your experience. I followed you
direction and I got it works.
Again, thank you!

Regards,
Pete
 
Top