Formula
 

I have two worksheets that I am linking. One worksheet is set-up
horizontally and the worksheet is set up vertically.

In other words I am trying to copy columns A, B, C, D, to rows 1,2,3,4

Thanks
--
DMM

Formula
 

The function you want is TRANSPOSE.
--
David Biddulph

"soconfused" wrote in message
...
I have two worksheets that I am linking. One worksheet is set-up
horizontally and the worksheet is set up vertically.

In other words I am trying to copy columns A, B, C, D, to rows 1,2,3,4

Thanks
--
DMM

Formula
 

=INDEX(Sheet1!$1:$1,ROWS($1:1))

Entered in Sheet2 and copied down.


Gord Dibben MS Excel MVP


On Wed, 6 Jun 2007 13:19:03 -0700, soconfused
wrote:

I have two worksheets that I am linking. One worksheet is set-up
horizontally and the worksheet is set up vertically.

In other words I am trying to copy columns A, B, C, D, to rows 1,2,3,4

Thanks