Is it possible to create a link between 2 Workbooks (such as Workbooks A & B in the screenshots below) which automatically updates? When the active cell in Workbook A is changed, I'd like Workbook B to display all instances of the value contained in that active cell, as well as all data associated with it.
1A.PNG
2B.PNG
3E.PNG
Bookmarks