I have this link from one workbook to another and I'm trying to change the last portion of the link (ABQ'!$S$77) to reference a 2 cells in WB (2015 Station Summary Report winter trough V2).. Basically, A1 would change tab names like ABQ, CLT.. and A2 would change a cell reference within that tab
The INDIRECT function can be used to build a cell reference from text values, but it only works with references to another workbook if that other workbook is open. If the other workbook is closed, the function will return #REF!
If 2015 STATION SUMMARY REPORT Winter Trough V2.xlsm is open, you can use