New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

copy data from a cell without automatically advancing to the next row

Macros, VBA, Excel Automation, etc.

copy data from a cell without automatically advancing to the next row

Postby ldstever » Tue Feb 02, 2016 12:11 pm

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.
  • 0

ldstever
Rookie
 
Posts: 1
Joined: Feb 2, 2016
Reputation: 0
Excel Version: 2007

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 33 guests