Note: As a way to use ImportRange, you have to are extra to be a viewer or collaborator for the spreadsheet from which ImportRange is pulling the data. If not, you will get this error: "#REF! mistake: The requested spreadsheet critical, sheet title, or cell range was not located." Developing https://rylanbvlad.blogchaat.com/37427334/hbs-case-study-help-an-overview