If I understand what you are trying to do it should work with "copy" then
"paste special" then choose "transpose". The only thing you need to remember
is that your paste location cannot include a cell from the copy location.

Hope this helps...
Steve

"RColeII" wrote:

I need to take a worksheet with columns A1, B1, C1, D1 and reformat those
into rows. I am able to create the first set using basic =worksheet2!A1, but
I can't copy paste because it defaults to =worksheet2!A5 due to the
intervening rows.

Suggestions?