chrisahlfCopper ContributorJul 27, 2020Workbook Dynamic Links We have "Work Orders" files on our server Z:, they are all named by "Job Number" i.e. 106574. Z:\REPORTS\Work Orders\106574.xlsx The total profit or loss on a job is in cell H52 in all cases. NOW,...Show More
BennadeauIron ContributorJul 27, 2020Hi chrisahlf,You are correct, "=indirect" should do the trick for you...=INDIRECT("'Z:\REPORTS\Work Orders\["&A1&".xlsx]Sheet1'!$H$52") Ben
