conditional copy between sheets google docs spreadsheets
- by user1891545
I have this situation:
1 spreadsheet with another 8 sheets
The sheet1 have 16 column fill from a web form, so when the people fill in its created a new row.
So i want create a script which read the rows and copy determined data column from this row in the specifics sheets
A B C D E F G H I J K L M N O P
1 X X X X X X X X X X X X X X X X
SHEET1 SHEET(F) SHEET(G) SHEET(H) SHEET4(I)...
If theres some data in column E copy column A, column B, column C, column E, from sheet1 to last row sheet E
also if theres no data on column E do nothing and continues
If theres some data in column F copy column A, column B, column C, column F, from sheet1 to last row sheet F
also if theres no data on column F do nothing and continues
....
Also I want know if is possible launch this script with function onSubmitForm() so as the row is insert automatically run the script and clasify the datas between the sheets.