Hi,
Can someone please help if I have the formula,
='C:\Users\HL02\Desktop\Training Plan\Training Plan IX (F-Day)\[_Template IX Training Plan.xlsx]General'!$F$11
in cell D12 and I want (_Template) to automatically update to the name I cell A12,
If A12 was Joe Bloggs...