yogi_Pull Values From Responses Sheet For A Given Row And Column And Then Drag Down To Pull Values From Every Second Successive Column In The Corresponding Row

                                          Google Spreadsheet   Post  #1373
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 19, 2013

user Greg B. Johnston (http://productforums.google.com/forum/?zx=x8ts4l41ygu7#!category-topic/docs/spreadsheets/iG9SJ8AMu7Y)
Pasting formula and choosing how many rows to increment?
Here's something like my data: https://docs.google.com/spreadsheet/ccc?key=0AoiOHFjFsZRfdGlONzFhYTlObU9YZFJUTkJCb2pIenc&usp=sharing

The goal is to pull data from the 'Responses' sheet columns C/D, E/F, and G/H into the 'Results' sheet as I have it. The purpose is to have each organization's numbers in a separate row in the 'Responses' sheet, but the same row in the 'Results' sheet. The problem is that when I drag down or copy and paste the formula, it increments the row references by 3s, rather than by 1s.

I'll look at the solution you posted and see if I can figure it out.
-----------------------------------------------------------------------------------------------------------------------------------------------------

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     www.energyefficientbuild.com.   Sep 10, 2013

user Greg B. Johnston (http://productforums.google.com/forum/?zx=8h90ovzom3m#!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.
----------------------------------------------------------------------------------------------------------------------------------------------------------