Forum Discussion
Create a dynamic reference in a Name Manager
Hello, I would like to know if it is possible to enter a dynamic refernce in a Name manager. A small example here : I have a reference to a workbook and the specified sheet and range for a defined...
It shall look like
=INDIRECT("'["&(Basis!$C$7)&"]KSB1N'!$O$2:$O$20000")but INDIRECT works if both files are opened
Thanks a lot. Do you know anything that would work with closed files a well?