Formula did not Change when Sort Filter is applied.

[dluhut]

Hello Excel Experts,

I have a formula in cell D10 of Sheet1

Please Login or Register  to view this content.

When I apply a filter to sort, and the "used to be" cell D10 is now in cell D11, the formula DID NOT automatically update from Sheet1!B10 to Sheet1!B11.

Does anyone knows how to make the formula to automatically change from the existing Sheet1!B10 to the 'newly' arranged row?

[dluhut]

Realized after that it could be due to 'Sheet1!'.

So if I were to take out the word 'Sheet1!', and just use B10, it fixed the problem