How do I transfer the contents of an EXCEL cell from Workbook #1 (in one subdirectory) to the cell in Workbook #2 (in another subdirectory)? The transfers must be continuous, so that whenever the Workbook #1 cell changes, the Workbook #2 will also change.
Solved by Z. E. in 11 mins