Hi!
Is it possible to have a dynamic workbook reference? like: 'C:\user\me\[cell value.xlsx]Sheet1'!$A1$:$A$10
I have tried to split it like ="'C:\user\me\["&cell value&".xlsx]Sheet1'!$A1$:$A$10" among others. I have tried to use INDIRECT, but I simply cant get it to work! Is it at all possible?
If it is, how I'm I supposed to wirte it?
Thanks!
Bookmarks