Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 20, 2012
user batt1eship said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/t48wmBLFVRg)
How to pull data from a one Spreadsheet (that collects through a form) and display only some results (and sort by date)
Ok, first off, this forum community rules, and as I get versed in this stuff, I ensure you that it is my intention to give back and answer as many questions as I can.
- I only want Science entries to populate, and we will call Spreadsheet 2 "Science" spreadsheet
- I then want the data, so both Jim's and Dan's entries to sort by newest to oldest on this new "Science" spreadsheet
- &, of course any new "Spreadsheet" entries with a "subject" of "science" in column D, I would like those to of course import automatically in the future to "Science Spreadsheet" and remain in "newest" to "oldest" format.