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

In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the workbook.

How do I do this?

share|improve this question
Your question is a bit unclear to me. You have one Spreadsheet and you want to import specific data into another spreadsheet, more specifically sheets? – Jacob Jan Tuinstra May 17 '13 at 21:25

You can't "push" a value (say from master spreadsheet to another) but you can "pull". So if A1 in Sheet1 is say 333 you can call that up in another sheet with =Sheet1!A1, or if say 01/01/1900 in Sheet1 you might give that a name, say bDay and use =bDay in another sheet to call up 01/01/1900.

Unfortunately I am not aware of a 'Group' facility for New Google Sheets (such as Excel has) and whatever you do seems will be required for each individual spreadsheet separately.

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.