Be aware: So that you can use ImportRange, you'll want to are actually added being a viewer or collaborator on the spreadsheet from which ImportRange is pulling the data. Usually, you will get this mistake: "#REF! mistake: The asked for spreadsheet essential, sheet title, or cell vary was not located." https://finnguqmu.aboutyoublog.com/44104933/a-secret-weapon-for-hbs-case-study-help