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.

Read the full story by


Secure On the Go Connections TCEA Responds: Starting a District Twitter Chat
We are updating our Privacy Policy, so please make sure you take a minute to review it. As of May 25, 2018 your continued use of our services will be subject to this new Privacy Policy.
Review Privacy Policy OK