Does this work for you?

=INDEX($12:$12,ROW(2:2))

And copy down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greg K." <Greg wrote in message
...
It seems like a simple thing to do but I just can't continue this pattern
in
excel. I'm sure it's just copying and pasting but I'm stuck. Also each is
a
4X4 matrix:
=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B13 =C13 =D13 =E13
=F13 =G13 =H13 =I13
=J13 =K13 =L13 =M13
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically? thank you.
-Greg K.