I have the following formulas on the third sheet of my workbook. They are simply cell references to the first sheet; on my 'output' page, I want to display every 17th cell of the 'input' sheet. However when I drag the formula down, it goes up in 2's. Any help gratefully appreciated.
=Input!B2 =Input!F10 =Input!F6 =Input!H11 =Input!F4 =Input!F13 =Input!F8
=Input!B19 =Input!F27 =Input!F23 =Input!H28 =Input!F21 =Input!F30 =Input!F25
(The use case is that I have "records" on the 'Input' sheet that are 17 rows high, and I want to display summary data on the 'Output' sheet in a one-row-per-record arrangement.)