![]() |
IS IT POSSIBLE?
to copy one excel file to other even when is updated the other file will be
automatically updated too? cheer |
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