Can you Mirror/Link cells on different sheets that work both ways?

Mister_J

New Member
Joined
Dec 14, 2017
Messages
20
Little bit of background:
I have set up an excel chart that allows me to track projects that I'm working on and update the status as phases are completed. It is not really being used to calculate values just track data that I need to monitor and update as tasks are completed. This chart contains a lot of projects but I have recently assigned some to someone else. I am trying to avoid the confusion of my entire chart and isolate the parts that have been assigned to the other person. So I have created a sheet 2 and I am trying to find a way to copy only the cells that the other person will be using/updating and set it up so any changes to sheet 1 will reflect on sheet 2 and changes made to sheet 2 will reflect on sheet 1.

Question:

Is there a way to set up specific sections of sheet 1 on sheet 2 that will be updated on both sheets when updated on one of the two sheets?

I am aware of the copy and paste (paste special > paste link) option but it seems to only work one way.

Any help would be greatly appreciated, Thanks!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top