Be aware: So that you can use ImportRange, you must have already been included being a viewer or collaborator towards the spreadsheet from which ImportRange is pulling the data. If not, you'll get this mistake: "#REF! mistake: The asked for spreadsheet essential, sheet title, or cell array wasn't found." The https://hbscasestudysolution86302.creacionblog.com/37054199/the-definitive-guide-to-hbs-case-help