Hello,

I have a sheet which is full of formulas linked to another sheet.
So far, the first 4 rows have numbers in them. The remaining 96 rows have DIV/0! error.
So what ive done is ive put a filter on to not show the DIV/0! error rows, ONLY the numbers.
However, as i change data on my other sheet, the DIV/0! errors on this sheet become numbers.
But because the filter is already applied, these numbers do not show up. I have to re-apply the filter every time.

My questions is: Is there a way for excel to automatically know that a cell has changed from DIV/0! to a number and so therefore displays it in the filter?

Thank you.