Hello Excel Experts,
I have a formula in cell D10 of Sheet1
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.=Sheet2!B1-Sheet1!B10
Does anyone knows how to make the formula to automatically change from the existing Sheet1!B10 to the 'newly' arranged row?
Bookmarks