Incremented Cell Referencing

[JordanPerks]

I am creating a spreadsheet that references another spreadsheet of mine and I am trying to find out how to reference every 16th cell in a column to every row in another column. I have a form on one sheet where users can enter all of their information and I want to create a separate overview sheet where the values are (for example) 1,2,3,4,5.... instead of 1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.......
I'm not particularly good with VBA but if that's what it takes to fix this issue then I would be willing to learn.

 

[Jonmo1]

Welcome to the board.

You can do this without VBA using a formula like
=INDEX(A:A,(ROWS($1:1)-1)*16+1)

The 16 is the interval (every 16 rows)
The +1 is the first row# to return value from
So this would get A1, A17, A33, A49 etc..

 

[bbott]

Assuming your form is on Sheet 2, try something like this:

=INDIRECT("Sheet2!A"&(ROW(A1)*16))

You would need to adjust for your tables. But this will increase by 16 rows each time you copy it down.