Note: In an effort to use ImportRange, you must are actually additional for a viewer or collaborator on the spreadsheet from which ImportRange is pulling the data. If not, you will get this mistake: "#REF! mistake: The requested spreadsheet critical, sheet title, or mobile range wasn't discovered." The good news https://hbscasestudysolution86302.creacionblog.com/37051036/helping-the-others-realize-the-advantages-of-hbs-case-study-solution