Forum Discussion
HELP ON REFERENCING ANOTHER WORKBOOK
I wonder if anyone can help me. I understand how to reference another workbook. However I am wanting to link another wookbook where the workbook name is quoted in the current sheet. I.E =[WK01.x...
ok thankyou, is there a way to do something similar where the wookbooks didn't have to be open. As this would progress to 52 weeks over the course of the year and thats a lot off wookbooks to have open at any one time just to compare and add up over the course of the year?
You may check this Referencing value in a closed Excel workbook using INDIRECT? if something will help, I didn't test what is suggested in it.