As mentioned by xor:
Quote:
Originally Posted by xor
Structure your data better. Your structure is not suitable for efficient formula building.<snip>
You might also want to take a look at Power Query.
|
Looking at some of the formulae in columns F, it seems you're interrogating files with a naming structure based on the date:
19-03-23-A.xlsx
and that sometimes you're looking at a sheet called DELEV-A, and sometimes DELEV-B. What determines which sheet is to be looked at? (Maybe there's only one sheet in each of such workbooks?)
It would probably be easier and more robust to grab the data for your current problem direct from these workbooks rather than via another workbook.
If you want to take this further, come back.