Hi, is there way to use the contents of a cell in one workbook to reference the contents of another workbook? For example, suppose in Workbook 1, A1 I have the word "Apple", in A2 is the word "Pear", in A3 is the word "Orange". Now, in B1 want the contents of cell B1 from another Workbook named "Apple.xls". In B2 I want the contents of cell B1 from another Workbook named "Pear.xls". I am wondering if there is a formula to make this possible so that I do not have to open every single workbook, but rather I can reference all of these workbooks by making the first column the name of each individual workbook? Thanks!
PS - If possible I'd like to make it so that it is a formula such that I don't need to change it with every single row/column, but instead it will automatically know that in B1 I want to reference the worksheet that uses A1 as the name, in B2 I want to reference the one with A2 as the name, etc. Sorry for making this so difficult!
Bookmarks