the answer of G7 in cell G230
the answer of G11 in cell G231, etc
In G230: =OFFSET($G$7,ROW(A1)*4-4,)
Copy G230 down
G230 returns the same as: =G7
G231 returns: = G11
G232 returns: =G15, and so on ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"To Old To . . ." wrote:
Created Formula for G7
=SUM(G4:G6)
and have copied it to other cells, i.e.
G11
=Sum(G8:G10), etc
- This Works Fine
Now what I want to do is:
the answer of G7 in cell G230
the answer of G11 in cell G231, etc
How can I do this.
If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not G11
Thank you for your help.