In my present (separate) workbook, I have a cell B8 labelled Monday and formatted as a text string. When I hit enter, the following string appears:
'[Reference file example.xlsx]Monday'!$B2
I need to be able to execute the command. I know it works, because if I copy and paste as plain text into another cell, then add an = sign at the beginning, it executes the command. How can I get the original string to execute the concatenated command?
I just got it to work the way you have it. I don't know what I was doing wrong, but I found a work around using the 2 step approach, which actually works better for what I was doing. Something I did in the past couple of hours fixed the syntax.