Cell Referencing and Lists

  • Thread starter Thread starter Adam Hart
  • Start date Start date
A

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
 
Try this from Sheet starting in Row 1:

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

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

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

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

Drag/copy down as far as you need.

Gord Dibben Excel MVP
 
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
 
Back
Top