Observe: So that you can use ImportRange, you have to are already additional to be a viewer or collaborator to your spreadsheet from which ImportRange is pulling the info. In any other case, you'll get this error: "#REF! error: The requested spreadsheet essential, sheet title, or mobile range wasn't located." https://deanhhngh.blogpayz.com/37421373/what-does-case-study-solution-mean