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