I am attempting to use a value in a cell in one file (value in A2{cell contains 'Wk 38 May 10, 2014'}) and the value in A2 is the name of a worksheet in another file, so I want to create a link formula that will use the value in A2 to identify the worksheet to reference to within the link formula.
Example='[Book2]Wk 38 May 10, 2014'!$A$10, would like to replace the 'Wk 38 May 10, 2014' with the value that is in cell A2 of the worksheet that contains the formula.
Example='[Book2]Wk 38 May 10, 2014'!$A$10, would like to replace the 'Wk 38 May 10, 2014' with the value that is in cell A2 of the worksheet that contains the formula.