formula referencing a column -> autofilling in a row ???

[Guest]

Hi, I'm doing a HW assignment for my accounting class. Here is my problem:

On sheet 1 I have some numbers in the column B4:B9

On sheet 2 I WANT to put those numbers in the row B4:G4 like so
B4 C4 D4
=+Sheet1!B4 =+Sheet1!B5 =+Sheet1!B6 ...


But when I try dragging the formula =+Sheet1!B4 to the right i get
B4 C4 D4
=+Sheet1!B4 =+Sheet1!C4 =+Sheet1!D4 ...

How do I make excel auto fill the formula the way I want it to?

I tried $B, but then the formula was the same ($B4) for every cell in the row.

Thank you,

CD

 

[Guest]

I forgot to mention that I must use cell referencing in my assignment.
That is, I can't just transpose the column to become the row I want.

 

[Guest]

in b4 on sheet2 enter
=indirect("Sheet1!B"&(column()+2))
copy across to G4