Forum Discussion
Solved
Reference another cell to complete a formula
Microsoft Office 2016 I would like a formula to be updated automatically when a new recipe is entered into another cell. For example.. ='[STATISTICS.xlsm]WK-5-18EF'!$B$4 the WK-5-18ef wou...
Made a typo. Obviously, it should be "STATISTICS.xlsm" between the brackets,
not "STATISTICS-xlsm". Recreated something similar on my own system and it works for me.
That comes up as a error...
Made a typo. Obviously, it should be "STATISTICS.xlsm" between the brackets,
not "STATISTICS-xlsm". Recreated something similar on my own system and it works for me.
Riny_van_Eekelen It also needed an extra apostrophe but it works! thank you.
That was the formula I had worked out. But I now realize that the workbook it references has to be open. If I close that workbook the formula does not work. Is there a way to change that?
