I'm looking for help building a formula referencing a range of cells on another worksheet and mirroring any merged cells. I have multiple schedules built in their own worksheet. Each row is a 5 minute range of time. So if a particular event is 30 minutes it would have 6 rows merged. Then there might be a 40 min block beneath it (8 cells merged). I want to mirror that in a separate worksheet so that if I change the number of merged cells or even the data in the cell, it gets reflected in the master schedule.