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

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.