This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan

Put in A1 and copy across:

=INDIRECT("Sheet2!A" & COLUMN())

HTH


"Dan Oakes" wrote:

This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan

That's it... perfect.

Thanks Topper,
-- Dan

Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan

To transpose a column to row try this entered in A1 of Sheet1

=OFFSET(Sheet2!$A$1,COLUMN(A1)-1,)

Drag/copy across row1 as far as you need.


Gord Dibben MS Excel MVP

On 15 Mar 2007 14:55:21 -0700, "Dan Oakes" wrote:

This has got to be very simple but I can't seem to figure it out...

On Sheet1 "A1" I have "=Sheet2!A1"
On Sheet1 "B1" I have "=Sheet2!A2"
On Sheet1 "C1" I have "=Sheet2!A3"

What function or symbol can I use to drag this formula so it keep this
pattern?
Is it transpose?

Thanks,
-- Dan

That's the one, thanks Gord.
-- Dan

Dan

=INDIRECT("Sheet2!B" & COLUMN()+19)

Entered in A1 of Sheet1


Gord

On 15 Mar 2007 15:33:36 -0700, "Dan Oakes" wrote:

Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan

Hi Dan

Try the non-volatile solution of
=INDEX(Sheet2!$B:$B,COLUMN(A1)+19)


--
Regards

Roger Govier


"Dan Oakes" wrote in message
ups.com...
Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan