In which case, just change the G$7 in my formula to C$7.
In your original message you did say:
"Whe I reference =G7 in cell c230 and reference G11 in cell c230, ..."
--
David Biddulph

"To Old To . . ." wrote in message
...
Maybe I didn't explain this correctly.
c7 is a formula for c3:c6
I want to place the answer also in cell c230
c11 is a formula for c8:c10
I want to place the answer also in cell c231

Thank you again

"David Biddulph" wrote:

=OFFSET(G$7,4*(ROW()-ROW(C$230)),0)
but you may need to sort out whether you're looking at C7 or G7.
--
David Biddulph

"To Old To . . ." wrote in message
...
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