Tuesday, February 15, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

GLukeQu said ...
I would like to export each row that is created from a form into it's own spreadsheet. I have attempted to import the data into a new spreadsheet but cannot figure how to pull the info automatically from the new row that the form creates. I can't figure out how to tell the new spreadsheet to pull info from the newest row (or a selected row) of the referenced spreadsheet.
So, let us go ...

For source data, I have created a spreadsheet
and for pulling the data from the latest row or select row, I have created