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