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.

This is what I'd like to do:

The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using formulas I would filter out the non-public data in the public sheet.

My understanding is that ImportRange will not let you reference a sheet you do not have direct access to, but I am no Google sheets wizard, there may be another way to accomplish my goals.

This seems to be pretty close, still digesting how to implement it: http://stackoverflow.com/a/14558223/2589506

Otherwise, I cannot have this automated, which would be lame.

Thanks for the help!

share|improve this question
    
I ended up using a Google script. Never used that before... heck, I didn't know it existed. It's really cool! Far better than Visual Basic scripting for Excel! –  Zoop Jul 19 '13 at 14:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.