PSD, I have had a quick look and though I'm sure you can streamline the DIR sheet I will concern myself only with Outreach sheet for now.
You make mention of Outreach No. as criteria for search yet I find no immediately obvious location where this criteria is set on Dir sheet so I am ignoring this and matching on name basis only for time being.
To avoid "expensive" formulae the best thing to do is to create a key on Paste Schedule sheet related to each value in Column A, eg:
If we assume data is not always sorted by Column A then
You can use this key on the Outreach sheet to avoid Arrays...
Next thing to do on Outreach sheet would be to create some cells to hold various values which would allow us to avoid repetitive / needless calculations in the main report:
Remaining formulae become:
point of the above being to use one formula for all cells in same column - should ease burden of maintenance.
Bookmarks