CODEWITHSUNDEEP
vbaexcel
KGK
KGK

Reputation: 107

How can auto sync cells in two excel files?

How Can sync Excel Cell's of different Document?. I would like to have two excel cell's on different Workbook to have the same information.

For Example: Let say i have Excel1.xls - Sheet1: Cell A1 = 400571 i would like: Excel2 - Sheet1:A1 to have the same information.

And if the content of Excel1/Sheet1/ A1 is changed i would like to change the value on Excel2.csv/Sheet1/A1.

Thank you!

Upvotes: 0

Views: 2858

Answers (1)

bp_
bp_

Reputation: 432

Your best bet is to search Google:

http://office.microsoft.com/en-us/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx

http://www.tech-recipes.com/rx/1604/excel_how_to_reference_cells_in_other_worksheets/

Upvotes: 1

Related Questions