Note: In order to use ImportRange, you have to are actually included to be a viewer or collaborator on the spreadsheet from which ImportRange is pulling the information. Or else, you'll get this error: "#REF! mistake: The requested spreadsheet critical, sheet title, or cell array wasn't discovered." After you need https://zanderktwur.wizzardsblog.com/37238525/what-does-hbs-case-help-mean