ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IS IT POSSIBLE? (https://www.excelbanter.com/excel-worksheet-functions/62134-possible.html)

duffy

IS IT POSSIBLE?
 
to copy one excel file to other even when is updated the other file will be
automatically updated too?
cheer

vezerid

IS IT POSSIBLE?
 
Duffy,
you can do it with a formula. With both workbooks open, in the
destination cell type "=" and then change workbook and point to the
cell, which you want copied. When you have pointed to the correct cell
press Enter to commit the formula and return to the cell.

If both workbooks are open changes in the source will be automatically
updated in the destination.
If destination only opens it will display the last saved value and ask
you if you want the link updated.

HTH
Kostis Vezerides



All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com