In response to post #4.
To get rid of the last IFERROR and speed this up as much as I can think of:
1. Place the following into cell K1 of the Issued sheet: =MAX(J:J)
2. Modify the formula in cell T12 and down on the MissingMaintReport sheet to read:
Formula:
=IF(ROWS(A$1:A1)>Issued!K$2,"",INDEX(Issued!B$2:B$11,AGGREGATE(15,6,(ROW(B$2:B$11)-ROW(B$1))/(Issued!$J$2:$J$11>=ROWS($A$1:$A1))/(Issued!$J$2:$J$11<>""),1)))
I assume that you mean you set the File > Options > Formulas > Calculation Options to Manual and after pasting the formulas you then pressed the F9 key (or selected calculated from the bottom left corner of the spreadsheet).
If that isn't the case you might try that.
I don't know enough about VBA to say whether or not thee is a way to do what you want in a faster manner, let alone how it would be done. If you would like the VBA contributors to look into the possibility then I suggest marking this thread as 'Solved' using the thread tools menu above your first post, and then opening a new thread on the VBA forum on this site.
You may want to include the attached file so that they can see what has been done to date.
Best of luck and I hope that you have a blessed day.
Bookmarks