Forum Discussion
Reference another cell to complete a formula
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?
True, INDIRECT doesn't work with closed workbooks. INDEX can do the trick, but at the moment I'm not able to look into this further.