I have a workbook with three different columns and within each column are approx. 245 formulas. Each formula in a column references a workbook and each column has a different workbook that is referenced. The referenced workbook is labeled in row 3, such as A, AA, and AC all reference workbooks A.xlsx, AA.xlsx, and AC.xlsx. Additionally, each cell has a fixed reference to the workbook. I need to figure out how to quickly change the formula so that it references the other workbooks based on the labeled row without having to go cell by cell and make the change. Ultimately I will be adding columns and external workbooks that the formulas will need to reference.
Any help is really appreciated!
Any help is really appreciated!
