(This question is mostly about Excel, but it's also relevant for LibreOffice Calc, so I welcome answers about either.)
I have this sheet with many rows, some of which only become relevant at certain times. I have a cell on that sheet indicating which is the last relevant row. Now, I have a PivotTable (and a PivotChart) which I always want to consider the currently-relevant data. Right now, whenever I change the the max relevant row I also change the Pivot Table's source range, manually. I was wondering whether I couldn't automate this by making it somehow use the last-relevant-row indicator cell for an indirect reference.