/docs/community?hl=en
/docs/community?hl=en
6/6/10
Original Poster
syivia

connect 5 spreadsheets together into 1 to see summary page for all of them in one extra doc.

Hi, I have got 5 different spreasheet with some summary numbers at the bottom. Of course each of them is shared with different people. Now I need 1 new speadsheet that would be able vlookup there sums from all the spreadsheet and put it into one. My question is about the real time changes made in 1 spreasheet - is it gonna updated the summary spreadsheet or whats the condition for updating the cells?
 
Thanks
sylvia





What browser and OS are you using?

Did clearing your cache and cookies resolve the issue? You can quickly clear your cache by refreshing your browser while holding the Shift key.
If your question is about documents or spreadsheets, were you using the new preview version?



Community content may not be verified or up-to-date. Learn more.
All Replies (6)
Yogi Anand
6/7/10
Yogi Anand
Hi Sylvia:
 
You can use the ImportRange ref [1] function to pull data into one spreadshhet from another -- the transfer of data may not be quite instantaneous -- check it out to see if it meets your needs.
 
Cheers!
Yogi

RV82
8/8/10
RV82
Hi Yogia,

Thanks for this great answer. This is exactly what I was looking for!

Except with MS Excel it is much easier to make the formula more dynamic.
In other words: if you copy the formula in a neighboring cell, it will adjust accordingly. For instance: Sheet1!A1 will turn into Sheet1!B1 if pasted horizontally.

Is there any way Google Docs has a more dynamic implementation of this function? If not, do you have any clever ideas to tackle this issue?

Hope you can help me out here.

Thanks in advance!

Yogi Anand
8/8/10
Yogi Anand
Hi RV82:

<Except with MS Excel it is much easier to make the formula more dynamic.
In other words: if you copy the formula in a neighboring cell, it will adjust accordingly. For instance: Sheet1!A1 will turn into Sheet1!B1 if pasted horizontally>

It is also so in working with Google spreadsheet -- try it and let us know how it works out for you.

Cheers!
Yogi
Henrique Abreu
8/9/10
Henrique Abreu
RV82, you can pass the whole range to only one importRange, like this: "Sheet1!A1:C3"
In Google Docs, formulas are allowed to expand it's value to other cells. It will automatically be filled with 'continue's formulas.

Regards,
Henrique Abreu
RV82
8/9/10
RV82
Hi Henrique,

thanks for that. This helps. It gets me in the right direction.

It all seems a bit unstable though. Updating cells takes a few minutes. Also when importing a larger range it must remain static as it is. You can not sort in in a different order. When doing so, the formula gets in trouble. In Excel this is a nice feature, because you are able to dynamically connect different workbooks, while still having the possibility to sort as you please.

Nevertheless: I am very happy with this new discovery! This being one of the last hurdles for our company to switch from MS to Google all together.

Greetings Remy
Henrique Abreu
8/9/10
Henrique Abreu
Well, it's not the same thing as sorting through the menu, but you can use the SORT function.
You can even wrap importRange with it, like this:
=SORT(importRange("spreadsheetKey";"Sheet1!A1:C3");1;false;2;true)
this will sort the first column descending and the 2nd ascending. Take a look at the doc [1] for more usages.

Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.