How to automatically pull data between different Google Spreadsheets

At EverSpark Interactive and H Creative Group we use Google Docs and Sheets to work simultaneously without having offline or duplicate files.

I needed to create a tracking sheet in Google Sheets that had a master page of data and sub pages of data for individual clients so I could show them only data related to them but I did not want to copy and paste. I wanted the sub pages to pull the data from the master when I updated data, thus eliminating a good amount of time. I found this post very helpful, he explains in order to do it you must use formula:

=importrange

Note: The spreadsheet key is the URL of the page you want to pull data from, the range is a rectangle/square area of data you want to select.

How to automatically pull data between different Google Spreadsheets

 

Thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s