Data Writer - Say goodbye to Import Range!

Have you ever needed to transfer data from one sheet to another and been frustrated by using ImportRange? Perhaps your data set is too large and slows down your sheet. Perhaps you want to be able to sort the data in the new location. 

This Google Sheet + Apps Script tool...

-Eliminates the use of import range and can keep data updated in multiple places from a single source.

-Automates the copying of data from spreadsheet to another on a large scale.

-Allows for data to be filtered prior to copying so only certain rows are copied.

-Can be set to run daily to automate the updating of key spreadsheets.

-Keeps a log so you can track what copies have occurred - records date, time, and how many rows were copied.

-Has a Roster Update feature that can update a tab in the destination sheet with a set of unique IDs to include any new rows that have been added to the dataset since the last copy.

This exists because.. I was spending hours copying reports into multiple spreadsheets, import range couldn't handle the quantity of data that I needed to move between sheets, and I wanted to be able to sort data (which import range doesn't allow!). I've saved 2+ hours each day using this tool to keep a variety of data tools updated from single source sheets.

It is great for...

-Updating content in multiple places from a single sheet (the results of a survey, a pasted report that you don't want to paste multiple times, etc.)

-Keeping rosters updated: maintain grade-level or class rosters in multiple sheets based on an entire school roster.