Formula to reference external workbooks

normanbox

New Member
Joined
Jul 8, 2015
Messages
44
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!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,099,501
Messages
5,468,976
Members
406,626
Latest member
jonathanbarrick

This Week's Hot Topics

Top