Note: So that you can use ImportRange, you need to are additional to be a viewer or collaborator on the spreadsheet from which ImportRange is pulling the information. Or else, you'll get this mistake: "#REF! error: The asked for spreadsheet important, sheet title, or cell variety wasn't uncovered." This publish https://hbscasestudysolution86302.creacionblog.com/37053919/the-single-best-strategy-to-use-for-hbs-case-help