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.

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets?

Each student will use a form to enter data to sheet: "Entries" like below:

http://img543.imageshack.us/img543/9161/98585819.jpg

How can I make the data in "Weekly Calendar" dynamic based on "Entries" semi-automatically(with a menu button) like below?

http://img20.imageshack.us/img20/2535/32601602.jpg

  1. Students fill the form (I can create the form)
  2. I click to menu entry "Sort Entries" to update the "Weekly Calendar" sheet. (I can create the menu entry and map it to necessary code)

I'm not a programmer. I'm using form e-mailers and ready-to-use codes. I have googled for this for hours but still no luck :(

Is it possible?

Appreciate the help. Thanks.

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.