Related Data Between 2 Different Workbooks

  • Thread starter Thread starter freeecoom
  • Start date Start date
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
 
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!
==============================================
 
Dear RagDyer,
Thank you very much for sharing your experience. I followed you
direction and I got it works.
Again, thank you!

Regards,
Pete
 
Back
Top