I have two workbooks with multiple sheets in each and although they are structurally identical contain varying data relating to the user. There is however one sheet I would like to add to both workbooks that is common, and I'd like to if possible share that particular sheet so that whenever either user updates it, it is saved in the others worksheet.
Naturally this is easy with a standalone sheet; make it a shared workbook problem solved.
Is there any way to share a common worksheet that is bi-directional?
"Paste Link" won't work in this situation.
Naturally this is easy with a standalone sheet; make it a shared workbook problem solved.
Is there any way to share a common worksheet that is bi-directional?
"Paste Link" won't work in this situation.