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!
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!