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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top