Be aware: So that you can use ImportRange, you might want to are already extra to be a viewer or collaborator on the spreadsheet from which ImportRange is pulling the data. If not, you'll get this mistake: "#REF! mistake: The requested spreadsheet critical, sheet title, or cell array wasn't found." https://emiliosyxel.blogkoo.com/hbs-case-study-help-an-overview-56600473