I think, you can change all cells in column N to use the Worksheet_Change event handler, to react to change in any of the cells in F:J columns, and temporarily restore formula in column N, recalculate it and store result as value
The code below is inserted in the sheet module (so right-click on the sheetname tab in excel window and select "display code"
I used the same mechanism for column M and repeating calls to xlookoop
But I've noted that there are also some potentialy computing power hungry formulas in other sheets (for instance Zone A filtered list), so test whether improvement in sheet Database really improved overall performance of the workbook - may be the cause is not in this sheet..
Final note - I decided to exclude row 2 from above tasks. It allows keeping there formulas in case some change in the boundary conditions is implemented.
And in writing temporarily a formula into M or N column I used two approaches - one is copying formula from row 2 and second: just write it directly as text. In the second approach all double quotes in formula have to be doubled so instead of formula
cell formula has to be written as:
Bookmarks