Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.

Scott_Ze1tz

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.

Paul Newcome

Have you looked into creating a report?

Scott_Ze1tz

Yes, and it helps with a single view, however, I am looking to have more of a two-way Sync.

Paul Newcome

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.