Exploring Google Sheets’ Functions: Import Range

“How do I get the numbers off this spreadsheet onto this other spreadsheet?” she gave me with a quizzical look. “If I copy and paste, I get the weird #REF! error.” Jessica had spent a lot of time working on several critical Google Sheets. Unfortunately, because of who she had to share each Google Sheet document with, she couldn’t put all the data together in ONE document to share. She wanted to have all the data flow into ONE Google Sheet so she could do some spreadsheet magic! 

As you may know, Google Sheets is a free, online, collaborative spreadsheet. It features functions, formulas, mail merge, and allows you to easily insert images, GANTT charts, and more. In this blog entry, please allow me to share a few common challenges of Sheets and tips for overcoming them. In spite of Google Sheets being around for several years, these questions continue to come up.