Change C7:C200 to whatever your actual range is. Note that if your data and
this formula are in the same worksheet in Column C, there is not enough room
between C7 and C230 (ie you are trying to pull more data than can exist in
the range C7:C229)

=INDEX(C$7:C$200,(ROWS(C$230:C230)-1)*4+1)



"To Old To . . ." wrote:

need to create a formula.

In Cell c230 = Cell c7
In Cell c231 = Cell c11
In Cell c232 = Cell c15
etc. How do I create a formula that I can copy and paste from cell c230 to
the other cells c231 thru c300.
Whe I reference =G7 in cell c230 and reference G11 in cell c230, copy and
paste gives me the incorrect formula.

Thank you for your help