Observe: As a way to use ImportRange, you have to are already added to be a viewer or collaborator on the spreadsheet from which ImportRange is pulling the info. If not, you will get this mistake: "#REF! error: The asked for spreadsheet key, sheet title, or cell array wasn't uncovered." https://martinnflnq.blog-kids.com/37581798/the-single-best-strategy-to-use-for-hbs-case-help