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)