Using data in rows in a table in columns.

[Guest]

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

 

[JE McGimpsey]

one way:

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

 

[JE McGimpsey]

Missed that you were starting in B2 rather than B1:

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

 

[RagDyeR]

Start *anywhere* with this:

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

--

HTH,

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

Missed that you were starting in B2 rather than B1:

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