Is there a way to make a formula like this work:
='N:\TTMA\TTMA-DieMnt\DPR\DPR 2010\[DPR 2010.xlsx]Totals'!G$113
But like this
="'N:\TTMA\TTMA-DieMnt\DPR\DPR "&A1&"\[DPR "&A1&"2010.xlsx]Totals'!"G$113
when I have 2010 in cell A1