Is it possible to change the external reference of the file ='[DDR RAP FINAL 2017.xlsx]Dashboard'!$C$61.
I have ID Codes in Column A. All my files are formatted by "ID Code" & RAP FINAL 2017.xlsx and i need the same cell location pulled from each file.
How is it possible to change DDR to the...