I'm updating Sheet2 of open Workbook 2025.xlsm through its userform. I want to be able to update a sheet named NEW with the exact same
structure in an external File(Book1.xlsm) so that both sheets reflect exactly the same data at all times.
This has been difficult for me because the code does not always work.
Does the external file need to be opened to be able to write to Sheet NEW in order to update it ?
BTW: linking won't work, because this effort needs to involve 2 way syncing - meaning I should be able to update 2025.xlsm from Book1 when I'm working in
that workbook that won't work since Sheet NEW contains linked formulas from 2025.xlsm.
Possible to do if one Workbook is closed ?
Thx for anyone's help.
cr
structure in an external File(Book1.xlsm) so that both sheets reflect exactly the same data at all times.
This has been difficult for me because the code does not always work.
Does the external file need to be opened to be able to write to Sheet NEW in order to update it ?
BTW: linking won't work, because this effort needs to involve 2 way syncing - meaning I should be able to update 2025.xlsm from Book1 when I'm working in
that workbook that won't work since Sheet NEW contains linked formulas from 2025.xlsm.
Possible to do if one Workbook is closed ?
Thx for anyone's help.
cr