[FIXED] How to reference a data range that keeps changing?

Issue

I have a report in my google sheets that updates automatically every 4 hours and adds new records to it, meaning that there are always new rows being added to it. In another overview sheet, I have a graph that refers to the data from the report. I have marked the data range as: 'REPORT'!A1:N119 But the reality is there will be new data added after cell N119, so I want to always include these automatically. How do I reference the data range? Do I absolute the cells?

Thanks for your help!

Solution

instead of 'REPORT'!A1:N119 use an open range: 'REPORT'!A1:N

Answered By - player0

Answer Checked By - Pedro (PHPFixing Volunteer)