I have an external database populating a spreadsheet in my workbook. In a separate worksheet in the same workbook, I use formulas to filter out a smaller subset of the query. The issue is any time I refresh the data, the cell references within the formulas for the smaller subset change. This happens any time a new element is added in the database.
I've tried using the
INDIRECT functions, but it won't allow me to use the $ symbol to prevent me from needing to individually change the formula
50,000 times (It is a very large database).
For further clarification on the problem:
My second spreadsheet is mainly entire columns of formulas like
Nothing complicated just that sort of stuff. But any time an element is added to the original database, and the data is refreshed in excel, the cell references are changed in the new sheet around the point where the new entries should be.