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.

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
add comment

1 Answer

You can't "push" a value (say from master spreadsheet to another) but you can "pull". So is 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
add comment

Your Answer

 
discard

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.