Take note: To be able to use ImportRange, you have to have been added like a viewer or collaborator for the spreadsheet from which ImportRange is pulling the data. Otherwise, you'll get this error: "#REF! mistake: The requested spreadsheet critical, sheet title, or mobile array wasn't observed." Make use of https://edgarfcbca.blog-a-story.com/18478165/the-single-best-strategy-to-use-for-hbs-case-help