copying a column reference into a row

I have a worksheet (sheet1) with a column of numbers (B2:B121). I would like
to reference these numbers on another worksheet (sheet2) but come over into a
row. I've tried using =sheet1(B2:B121), but I can't get these numbers to go
horizontally in a row.

Copy the column, then PasteSpecial - Transpose. HTH Otto
"lars1028" <[email protected]> wrote in message
news:[email protected]...
>I have a worksheet (sheet1) with a column of numbers (B2:B121). I would
>like
> to reference these numbers on another worksheet (sheet2) but come over
> into a
> row. I've tried using =sheet1(B2:B121), but I can't get these numbers to
> go
> horizontally in a row.

Copy > PasteSpecial > Transpose

Vaya con Dios,
Chuck, CABGx3



"lars1028" wrote:

> I have a worksheet (sheet1) with a column of numbers (B2:B121). I would like
> to reference these numbers on another worksheet (sheet2) but come over into a
> row. I've tried using =sheet1(B2:B121), but I can't get these numbers to go
> horizontally in a row.

Thanks a lot, it worked perfectly


"Casey" wrote:

>
> lars,
> Try:
> ={TRANSPOSE(Sheet1!B2:B121)}
> This is an array formula. The exact same formula will be in all cells
> on Sheet2. Array formulas have to be entered using CTRL>SHIFT>ENTER.
> If this is your first time, here are the exact steps I used.
> 1. On Sheet2 select the horizontal range you want the Sheet1 values to
> go into.
> 2. With the range highlighted hit =
> 3. In the formula bar type in TRANSPOSE(Sheet1!B2:B121)
> 4. Hit and hold CTRL then SHIFT then ENTER.
> 5. The {} brackets will be added to your formula and you are done.
> HTH
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=553302
>
>