Linking cells to a child cell in another worksheet
I have created a Summary Worksheet to capture high-level milestones from a collection of project plans. The way I set up the summary tracker is to create a parent-child relationship under each project and am trying to link the start and end dates from the original project plan to this summary worksheet. The challenge I am having is with the Dependencies box checked which allows changes in the child rows to auto-update the parent row the End Date cell will not allow me to link from another sheet. This requires double-entry for the project managers on both the core project plan and then on the summary worksheet.
Is there any way to get the cell linking feature to work while dependencies are enabled?