Note: To be able to use ImportRange, you must are already added as a viewer or collaborator to the spreadsheet from which ImportRange is pulling the data. Or else, you will get this mistake: "#REF! mistake: The asked for spreadsheet essential, sheet title, or mobile selection was not observed." This https://case-study-solution20521.sharebyblog.com/37063731/not-known-facts-about-pay-someone-to-write-my-harvard-case-study