'Mirror worksheet between two workbooks
What I am trying to achieve is as follows, I have "Workbook A" and "Workbook B", within Workbook B there is a worksheet "SheetB2" which I would like to be included in Workbook A. However, any changes made to SheetB2 in Workbook A I would like to be replicated to the corresponding worksheet in Workbook B and vice versa.
Is this possible within excel utilizing built in tools or VBA?
Could people point me in the direction of the tools or VBA scripting that would be required to make this possible? I'd imagine there will be a number of steps to a suitable solution.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|