Wednesday, September 18, 2013

yogi_Pull Into Another Sheet Every Nth Row Starting From A Specified Row Number Of Form Responses Sheet

                                          Google Spreadsheet   Post  #1371
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep 10, 2013
user Greg B. Johnston (!category-topic/docs/spreadsheets/iG9SJ8AMu7Y)
Pasting formula and choosing how many rows to increment?
I have a set of formulas in merged cells that each cover three rows. I want to be able to copy and paste the formula to a spot three rows lower, while only incrementing the cell number in the formula by 1; I'm referencing another sheet, so it's important that I only go down one row of data at a time.

In other words, I'll paste something like ='Form Responses'!A2 into row 5. I want ='Form Responses'!A3, not ='Form Responses'!A5.

Is there a way to do this?

I'm using Google Docs on Firefox/Windows 8.