I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want to
pick these values up and use them else where in a table arranged in columns.
Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the
second row (cell B3) will be =Sheet1!C2, the third row (cell B4) will be
=Sheet1!D2 etc.

If I copy or drag the formula down the rows I end up with the incorrect
references (the row value increments, but not the column value) as you would
expect. Is there any way to drag down or copy the formulas to pick up the
data as I have tried to describe above? - or do I have to enter the formula
for each cell?

Thanks,

Andy

one way:

=INDEX(Sheet1!$2:$2,ROW()+1)

In article ,
Andy wrote:

I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want to
pick these values up and use them else where in a table arranged in columns.
Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the
second row (cell B3) will be =Sheet1!C2, the third row (cell B4) will be
=Sheet1!D2 etc.

If I copy or drag the formula down the rows I end up with the incorrect
references (the row value increments, but not the column value) as you would
expect. Is there any way to drag down or copy the formulas to pick up the
data as I have tried to describe above? - or do I have to enter the formula
for each cell?

Thanks,

Andy

Missed that you were starting in B2 rather than B1:

=INDEX(Sheet1!$2:$2,ROW())


In article ,
JE McGimpsey wrote:

one way:

=INDEX(Sheet1!$2:$2,ROW()+1)

In article ,
Andy wrote:

I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want to
pick these values up and use them else where in a table arranged in
columns.
Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the
second row (cell B3) will be =Sheet1!C2, the third row (cell B4) will be
=Sheet1!D2 etc.

If I copy or drag the formula down the rows I end up with the incorrect
references (the row value increments, but not the column value) as you
would
expect. Is there any way to drag down or copy the formulas to pick up the
data as I have tried to describe above? - or do I have to enter the formula
for each cell?

Thanks,

Andy

Start *anywhere* with this:

=INDEX(Sheet1!$2:$2, ROWS($1:2))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"JE McGimpsey" wrote in message
...
Missed that you were starting in B2 rather than B1:

=INDEX(Sheet1!$2:$2,ROW())


In article ,
JE McGimpsey wrote:

one way:

=INDEX(Sheet1!$2:$2,ROW()+1)

In article ,
Andy wrote:

I have a series of data in rows (eg. in cells B2, C2, D2, E2...). I want
to
pick these values up and use them else where in a table arranged in
columns.
Therefore the formula in the first row (cell B2) will be =Sheet1!B2, the
second row (cell B3) will be =Sheet1!C2, the third row (cell B4) will be
=Sheet1!D2 etc.

If I copy or drag the formula down the rows I end up with the incorrect
references (the row value increments, but not the column value) as you
would
expect. Is there any way to drag down or copy the formulas to pick up
the
data as I have tried to describe above? - or do I have to enter the
formula
for each cell?

Thanks,

Andy