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!