Forum Discussion
Extract Row Number from Formula
Hi! I have a workbook set up that pulls linked data from another workbook and summarizes it. The row numbers in these links will change from time to time, and I'd like to update the formulas usin...
As often is the case, Excel offers more than one way to get from point A to point B.
I have a similar situation where, instead of using VBA or some other brute force method, I have a "utility tab" that stores changeable items like those cell references. I then use INDIRECT in the formula that does the calling of those remote sheets, and in the INDIRECT refer to the utility cells...
Here's a great reference that explains how to use INDIRECT
https://exceljet.net/excel-functions/excel-indirect-function