Sheet share

[effka]

Hello,

Can somebody help me with the task?
There are two different excel workbooks in different Teams groups. Those workbooks are activity trackers with many different sheets, but there is one sheet (let's call it sheet "A") that is the same for both workbooks. At this moment, after making changes on sheet "A" in one workbook, the same changes must be made on sheet "A" of another workbook. I want that sheet "A" to be freely accessible and corrected from both workbooks (no need to enter the same information twice), is there any way to do that?

 

[RoryA]

You can't share just one sheet. It would have to be a separate workbook.

 

[Trixterz]

Use formula to dynamically link Workbook-B to another to Workbook-A and only make changes in Workbook-A and it will dynamically transfer over to Workbook-B.

=[Workbook-A.xlsb]Sheet1!$A$1

Workbook Path & Name: Workbook-A.xlsb
Sheet Name: Sheet1
Cell to Reference: $A$1