IMPORTRANGE necessitates each the sheet URL and a data vary to get specified. You could’t specify One more complete workbook by including just the URL. While you can manually write the sheet_name and cell-reference, you can also form “=” and navigate to the other worksheet to choose your required cell https://brooksqfhtx.wssblogs.com/37131069/the-greatest-guide-to-hbs-case-study-help