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.

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.

"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 as in 14,15,16...etc. with the last row always being 0 0 0 1 ? thank you.
-Greg K.

I don't think that's exactly what I'm looking for or I may be copying down
wrong, but thank you anyway ragdyer. Any other suggestions would be greatly
appreciated.
-Greg



"Ragdyer" wrote:
Does this work for you?

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

And copy down.
--
HTH,

RD

"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.

I should have been more clear in my question but I need to find a way to
continue this pattern (as stated in my last 9/3 post) rather than actually
copy and paste it somewhere else. (I want to be able to drag this pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0 0 0 1 ?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be greatly
appreciated. Thank you.
-Greg

If that's all you want to do, just select the *entire first* set, grab the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find a way to
continue this pattern (as stated in my last 9/3 post) rather than actually
copy and paste it somewhere else. (I want to be able to drag this pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0 0 0 1
?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be
greatly
appreciated. Thank you.
-Greg

Doesn't that give you:

=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B16 =C16 =D16 =E16
=F16 =G16 =H16 =I16
=J16 =K16 =L16 =M16
0 0 0 1
because you are going down 4 columns from the previous 16 cell set? Is it
possible to get the B13 set next instead of the B16 cell set or am I doing
something wrong?
-Greg


"Ragdyer" wrote:

If that's all you want to do, just select the *entire first* set, grab the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find a way to
continue this pattern (as stated in my last 9/3 post) rather than actually
copy and paste it somewhere else. (I want to be able to drag this pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0 0 0 1
?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be
greatly
appreciated. Thank you.
-Greg

Let's start from the beginning, so that we're both talking about apples, and
*not* apples and oranges.

How are you entering the data
=B12
into a cell?
AND ...
Exactly what is
=B12
?

Is it a formula ...
Is the cell it's entered into pre-formatted as Text?
Is the cell it's entered in formatted as General, and the data is prefixed
with an apostrophe?

My data was copied into a new sheet, into Text pre-formatted cells, from
your post.

I just manually entered your data into General formatted cells, prefixed
with an apostrophe ... AND ... the copy results were identical to my first
test ... *EXACTLY* what you're looking for.

So, my results were attained on Text values.

SO ... What exactly is the form of your data?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greg K." wrote in message
...
Doesn't that give you:

=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B16 =C16 =D16 =E16
=F16 =G16 =H16 =I16
=J16 =K16 =L16 =M16
0 0 0 1
because you are going down 4 columns from the previous 16 cell set? Is it
possible to get the B13 set next instead of the B16 cell set or am I doing
something wrong?
-Greg


"Ragdyer" wrote:

If that's all you want to do, just select the *entire first* set, grab
the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find a way
to
continue this pattern (as stated in my last 9/3 post) rather than
actually
copy and paste it somewhere else. (I want to be able to drag this
pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0 0
0 1
?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be
greatly
appreciated. Thank you.
-Greg

Just manually entered all your data as *formulas* into "General" formatted
cells, and I *did* get the same results as you ... B12 incremented to B16
during a "copy".

So, you have your solution!

Enter the primary set of data as text, complete your copying, then transform
the entire range to formulas.

Format your primary *12* cells to Text.
Leave the 0 - 0 - 0 - 1 row as General.
Enter your data.
Do your copying.

Select the entire range of copied data.
<Ctrl <Shift < ~
To change the format of the range to General,
Then, while everything is *still* selected,
<Edit <Replace
Find what, enter
=
Replace with what, enter
=
Then click "Replace All".

You should now have what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Let's start from the beginning, so that we're both talking about apples,
and
*not* apples and oranges.

How are you entering the data
=B12
into a cell?
AND ...
Exactly what is
=B12
?

Is it a formula ...
Is the cell it's entered into pre-formatted as Text?
Is the cell it's entered in formatted as General, and the data is prefixed
with an apostrophe?

My data was copied into a new sheet, into Text pre-formatted cells, from
your post.

I just manually entered your data into General formatted cells, prefixed
with an apostrophe ... AND ... the copy results were identical to my first
test ... *EXACTLY* what you're looking for.

So, my results were attained on Text values.

SO ... What exactly is the form of your data?
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
Doesn't that give you:

=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B16 =C16 =D16 =E16
=F16 =G16 =H16 =I16
=J16 =K16 =L16 =M16
0 0 0 1
because you are going down 4 columns from the previous 16 cell set? Is
it
possible to get the B13 set next instead of the B16 cell set or am I
doing
something wrong?
-Greg


"Ragdyer" wrote:

If that's all you want to do, just select the *entire first* set, grab
the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD



--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!


--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find a
way
to
continue this pattern (as stated in my last 9/3 post) rather than
actually
copy and paste it somewhere else. (I want to be able to drag this
pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0
0
0 1
?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be
greatly
appreciated. Thank you.
-Greg

Thank you very much Ragdyer.
-Greg

"Ragdyer" wrote:

Just manually entered all your data as *formulas* into "General" formatted
cells, and I *did* get the same results as you ... B12 incremented to B16
during a "copy".

So, you have your solution!

Enter the primary set of data as text, complete your copying, then transform
the entire range to formulas.

Format your primary *12* cells to Text.
Leave the 0 - 0 - 0 - 1 row as General.
Enter your data.
Do your copying.

Select the entire range of copied data.
<Ctrl <Shift < ~
To change the format of the range to General,
Then, while everything is *still* selected,
<Edit <Replace
Find what, enter
=
Replace with what, enter
=
Then click "Replace All".

You should now have what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Let's start from the beginning, so that we're both talking about apples,
and
*not* apples and oranges.

How are you entering the data
=B12
into a cell?
AND ...
Exactly what is
=B12
?

Is it a formula ...
Is the cell it's entered into pre-formatted as Text?
Is the cell it's entered in formatted as General, and the data is prefixed
with an apostrophe?

My data was copied into a new sheet, into Text pre-formatted cells, from
your post.

I just manually entered your data into General formatted cells, prefixed
with an apostrophe ... AND ... the copy results were identical to my first
test ... *EXACTLY* what you're looking for.

So, my results were attained on Text values.

SO ... What exactly is the form of your data?
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
Doesn't that give you:

=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B16 =C16 =D16 =E16
=F16 =G16 =H16 =I16
=J16 =K16 =L16 =M16
0 0 0 1
because you are going down 4 columns from the previous 16 cell set? Is
it
possible to get the B13 set next instead of the B16 cell set or am I
doing
something wrong?
-Greg


"Ragdyer" wrote:

If that's all you want to do, just select the *entire first* set, grab
the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD



--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!


--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find a
way
to
continue this pattern (as stated in my last 9/3 post) rather than
actually
copy and paste it somewhere else. (I want to be able to drag this
pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0
0
0 1
?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be
greatly
appreciated. Thank you.
-Greg

Glad it all got squared away.

The largest hurdle in these groups is not having to *solve* the problems,
but in the OP's ability to make their problem comprehensible to a large,
varied congregation, and in that congregation's adeptness to interpret the
OP's often abbreviated and/or awkward attempts at an explanation of their
predicament.

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Greg K." wrote in message
...
Thank you very much Ragdyer.
-Greg

"Ragdyer" wrote:

Just manually entered all your data as *formulas* into "General"
formatted
cells, and I *did* get the same results as you ... B12 incremented to
B16
during a "copy".

So, you have your solution!

Enter the primary set of data as text, complete your copying, then
transform
the entire range to formulas.

Format your primary *12* cells to Text.
Leave the 0 - 0 - 0 - 1 row as General.
Enter your data.
Do your copying.

Select the entire range of copied data.
<Ctrl <Shift < ~
To change the format of the range to General,
Then, while everything is *still* selected,
<Edit <Replace
Find what, enter
=
Replace with what, enter
=
Then click "Replace All".

You should now have what you're looking for.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"Ragdyer" wrote in message
...
Let's start from the beginning, so that we're both talking about
apples,
and
*not* apples and oranges.

How are you entering the data
=B12
into a cell?
AND ...
Exactly what is
=B12
?

Is it a formula ...
Is the cell it's entered into pre-formatted as Text?
Is the cell it's entered in formatted as General, and the data is
prefixed
with an apostrophe?

My data was copied into a new sheet, into Text pre-formatted cells,
from
your post.

I just manually entered your data into General formatted cells,
prefixed
with an apostrophe ... AND ... the copy results were identical to my
first
test ... *EXACTLY* what you're looking for.

So, my results were attained on Text values.

SO ... What exactly is the form of your data?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit !

--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
Doesn't that give you:

=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B16 =C16 =D16 =E16
=F16 =G16 =H16 =I16
=J16 =K16 =L16 =M16
0 0 0 1
because you are going down 4 columns from the previous 16 cell set?
Is
it
possible to get the B13 set next instead of the B16 cell set or am I
doing
something wrong?
-Greg


"Ragdyer" wrote:

If that's all you want to do, just select the *entire first* set,
grab
the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!
--
HTH,

RD




--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!



--------------------------------------------------------------------------
-
"Greg K." wrote in message
...
I should have been more clear in my question but I need to find
a
way
to
continue this pattern (as stated in my last 9/3 post) rather
than
actually
copy and paste it somewhere else. (I want to be able to drag
this
pattern
down until row 523).

=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

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .

=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this
pattern
vertically as in 14,15,16...523. with the last row always
being 0
0
0 1
?
I apologize to Harlan for not being as clear as I should have
been.
Does anyone have an idea of how to do this? Feedback ASAP would
be
greatly
appreciated. Thank you.
-Greg