=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