Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IS IT POSSIBLE?
to copy one excel file to other even when is updated the other file will be
automatically updated too? cheer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|