I am copying data from the formresponse sheet to another sheet within the same workbook. I want the information from the form response sheet to automatically copy over to the cells in another sheet.
For example: "FormResponse2!A2" into JI34
"FormResponse2!A3" to J146
"FormResponse2!A4" to J158
"FormResponse2!A5" to J170 and so on..
I started out with FormResponse2!A2 continuing with the above pattern and when a Google Form was submitted the formula in the "J" cells automatically advanced to the next row. I also tried FormResponse2!$A$2, =query(FormResponse2!A2) and neither of these worked.
I have been manually entering the formula into each cell and then after a Google Form is submitted I have to update each cell.