I have a dashboard with cells reference to another source sheet. Sometimes colleagues add rows in the source sheet (cell reference changes). I need to set up such that when the rows are added (cell reference changes) the dashboard is not affected. I.e the cell reference moves as well.
Solved by C. L. in 20 mins