Cell Referencing and Lists

[Adam Hart]

I am trying to reference every 20 cells in sheet1 in
sheet2 without having to copy the formula hundreds of
times. I have tried the following: Sheet1!G20 in one
cell, Sheet1!G40 in one cell, Sheet1!G60 in one cell and
tehn highlighting and dragging, but the program just
increments the cell reference by 3 so the next set of
formulas refer to G23, G43, G63. I want to have the list
increment by 20. Can anyone help?????

Thanks

 

[Charles Maxson]

Try this from Sheet starting in Row 1:

=INDIRECT("Sheet1!G"&ROW()*20)

Then copy it down as far as you need...

 

[Gord Dibben]

Adam

In A1 on Sheet2.........

=INDIRECT("Sheet1!G"&ROW()*20)

Drag/copy down as far as you need.

Gord Dibben Excel MVP

 

[adam]

Thank you both. Using the indirect function and a
variation of what each of you said, I was able to
accomplish what I needed! Kudos!!!
Happy New Year. Adam