"Greg K." wrote...
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.

If you want the B12 result in, say, X99 so that the L12 result would be in
Z101, then use the formula

X99:
=IF(MOD(ROWS(X$99:X99),4),INDEX($B$12:$M$13,
INT((ROWS(X$99:X99)-1)/4)+1,MOD(ROWS(X$99:X99)-1,4)*4
+COLUMNS($X99:X99)),--(COLUMNS($X99:X99)=4))

Select X99 and fill right and down into X99:AA106.