Hi,
Apologies for the rubbish title. I have lots of formula's that reference other worksheets in other files and rather than keep typing the full path into each formula i was wondering if i could store the location in a cell and then reference that via my formula.
i.e. A1 =[Worksheet1.xlsx]Sheet1!
current formula = (INDIRECT("[Worksheet1.xlsx]Sheet1!M"&$E$2))
but replace = [Worksheet1.xlsx]Sheet1! with A1
Is that possible ?
Thanks
Apologies for the rubbish title. I have lots of formula's that reference other worksheets in other files and rather than keep typing the full path into each formula i was wondering if i could store the location in a cell and then reference that via my formula.
i.e. A1 =[Worksheet1.xlsx]Sheet1!
current formula = (INDIRECT("[Worksheet1.xlsx]Sheet1!M"&$E$2))
but replace = [Worksheet1.xlsx]Sheet1! with A1
Is that possible ?
Thanks