Thursday, February 3, 2011

yogi_Filtering Form Submitted Data Into Separate Sheet For Each Day



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



Form submitted data is in the sheet BookData

I have created a sheet named 2011-01-01 to filter data for the day 1-Jan-2011 only, and
I have created a sheet named 2011-01-02 to filter data for the day 2-Jan-2011 only

In the day sheets, I have keyed in the day (sheet name) in cell A1

formula in cell A2 to write headers is ...
=ArrayFormula(BookData!A1:D1)

and

formula in cell A3 to filter the data for the day is ...
=filter(BookData!A2:D,int(BookData!A2:A)=A1)