Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I book reservations for a sports team and need to be able to communicate with other parts of the arena what hospitality areas are booked/available. In the past there have been multiple e-mails, reports and spreadsheets which have made everyone's jobs harder. We used a Google Doc last year for the majority of the departments, which worked well, BUT we can not share customer contact information with their sales department for obvious reasons.

Is there a way to either block certain information from view or to have the mastersheet fill into another spreadsheet which can block certain cells or information?

This is an example of the information from the mastersheet.

share|improve this question

I believe the Google spreadsheet function ImportRange= will solve your problem. It will import cells from one spreadsheet to another. Then you can share only the spreadsheet you want with the sales department.

Here is Google's function list.

Alternatively, if you just need to accept data from a group/individual but not show them anything in return, you can make a form in Google Drive. The form can be sent out and when the recipient fills it out you get the results as a spreadsheet.

share|improve this answer

Your Answer


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

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