Take note: In order to use ImportRange, you'll want to happen to be included like a viewer or collaborator into the spreadsheet from which ImportRange is pulling the data. Or else, you will get this mistake: "#REF! error: The requested spreadsheet vital, sheet title, or cell selection wasn't uncovered." This https://case-analysis87873.blazingblog.com/37234174/not-known-facts-about-pay-someone-to-write-my-harvard-case-study