Sorry tim, this didn't help. When I clicked transpose, the paste link button
disabled. Need to paste the links. Thnx so much anyway.

"tim m" wrote:

Copy....paste special....transpose.

"cioangel" wrote:

I need to paste links from one workbook to another in Excel. The source cells
are 4 vertical cells whereas the paste cells are 4 horizontal cells. Excel
does paste the links only vertically matching the source cells. How can I
take the information from the 4 vertical cells and place the links into 4
horizontal cells in another workbook?