Excel Cells with external sheets
Posted on 2014-10-02
Hello Experts Exchange
I have a spreadsheet that has formulas that point to different spreadsheets, for example a cell has the following formula.
Is it possible that I have this formula built by have the file location in a cell?
So for example.
Cell A1 has this in it;
Then cell A2 uses cell A1 to make it formula, so it will have;
=A1 & C32
Then it will get the information from cell c32 from the spreadsheet detailed in A1?