Hello,
Is it posible to have the name of a saved .xls file for instance "Jan P L" in a cell
and then link this with the formular in a the same workbook so if the cell name changes say to "Feb P L" it will look at the new file and update the information on the sheet.
I can link the two files so that it looks at the correct file with this formula in the cell but if i need it to change Month I cannot get it to work as I need to set the formula to change the reference file name.
='C:\Users\User name\Desktop\[Jan PL.xls]Sheet1'!$F$10
Thank you for your time
Is it posible to have the name of a saved .xls file for instance "Jan P L" in a cell
and then link this with the formular in a the same workbook so if the cell name changes say to "Feb P L" it will look at the new file and update the information on the sheet.
I can link the two files so that it looks at the correct file with this formula in the cell but if i need it to change Month I cannot get it to work as I need to set the formula to change the reference file name.
='C:\Users\User name\Desktop\[Jan PL.xls]Sheet1'!$F$10
Thank you for your time