I know reports are the more favorable way to go with this but that won't work for what I need.
Use Case: Departments have a tracking sheet with high-level detail. Other departments want to track various level of detail in their own sheet. Only some of that data needs to make it back to the roll up sheet for executive leaders.
I have a source sheet and a destination sheet. Both sheets have a Dashboard Checkbox.
What I want to do is if the Dashboard Column is checked in the source sheet, then pull in the source data from the other columns to the reference sheet.
We want the cells to be linked so that they update progress in the destination sheet as well.
Again, I know a report would accomplish this easily but that's not what works here
