Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Possible Duplicate:
Can we do a link between two Google Docs spreadsheets?

I'm trying to link two Google spreadsheets. I don't want to merge

I would like to have a spreadsheet with the data of my clients and link with the. I can't have the data in the same spreadsheet because I've shared with people and they can't see all the data of my clients

Then I'll have my sales in one document and in other I can have the resume of the data

share|improve this question

marked as duplicate by Mehper C. Palavuzlar, ChrisF Oct 26 '12 at 10:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
It sounds a little different than your link. I think what he meant was cross sheet referencing. –  designerWhoCodes Oct 23 '12 at 19:16

1 Answer 1

Don't click on it, just pay attention to the URL format.

Examine an example spreadsheet URL https://spreadsheets.google.com/ccc?key=0AqhqY231XZd3cFBiY2VqeWdmNWdhaDBqTnNxVi1sVlE&hl=en

In this URL the bolded section 0AqhqY231XZd3cFBiY2VqeWdmNWdhaDBqTnNxVi1sVlE between key= and &hl= is the key.

We are going to use ImportRange to cross reference the spreadsheet. Here is the sample format =ImportRange( "KeyName" ; "SheetName!FirstCell:LastCell" )

This isn't fool proof, but it will give you the ability to include data from hidden sources and protect the sensitive numbers from being seen by other clients.

share|improve this answer
    
Without the link this answer is useless. Answers should be complete in and of themselves. At best this should be a comment. –  Al E. Oct 23 '12 at 19:53
1  
I have updated the answer, and written clear instructions now. –  designerWhoCodes Oct 23 '12 at 20:50
    
Thanks!!It works great –  Borja Monforte Oct 24 '12 at 9:03
    
Borja, If this answer is satisfactory please mark this as the accepted answer please. –  designerWhoCodes Oct 24 '12 at 14:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.