Forum Discussion
LEE_STEWART
Nov 29, 2020Copper Contributor
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...
mathetes
Nov 29, 2020Gold Contributor
I agree with the advice given by HansVogelaar
Here's a reference that may give further guidance on the use of INDIRECT: https://exceljet.net/formula/indirect-named-range-different-sheet