Related Data Between 2 Different Workbooks

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!
==============================================


"freeecoom" <freeecoom.1vu12a_1127513104.3977@excelforum-nospam.com> wrote
in message news:freeecoom.1vu12a_1127513104.3977@excelforum-nospam.com...
>
> 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
>
>
> --
> freeecoom
> ------------------------------------------------------------------------
> freeecoom's Profile:
http://www.excelforum.com/member.php...o&userid=27507
> View this thread: http://www.excelforum.com/showthread...hreadid=470378
>

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

Regards,
Peter