Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.
I am looking to have sheets have a bi-directional sync between worksheets. Wanted it to be more of a Parent/Child relationship, where the Parent sheet can have 1 or more Child sheets roll up into it. While allowing the editing and syncing of each child sheet by both sheet editors. Scheduled or near real-time bi-directional sync.
The Master sheet owner can edit both Master and Child sheets. The child sheet can only edit the Child sheet.
Looking for options.
Answers
-
-
Yes, and it helps with a single view, however, I am looking to have more of a two-way Sync.
-
It is a two way sync in a report. That is actually the only way to be able to update a cell from two different locations.
