to transfer Formula relsults in a row to cells in a cloumn in another workbook

Hellow every body!

I have sum formula results in cells in a row, say E16, F16, G16.......... in a workbook, I want to show these formula results in the cells in a column of another workbook, say D3, D5, D7, D9........ Can this be done some dragging or copying specially without giving link one by one?

Javid

I tried it, by copying all formulas in cells of one row, then selected same number of cells in the column of destination workbook, went to paste special and clicked paste link, but it did'nt work.

Hope I understand the problem correctly.

Try copying the cells, the select the destination cell, select "Paste Special", tick "Transpose" (depending on which version of Excel you have). This turns a copy of horizonal cells into a vertical paste cells.

Any good?

i have already tried this, it does not work. Please tell me the version if you know in that it works in this way.

Hello everyone,
I could not have the solution so far. Actually I want to use the Transpose with Paste Link, whereas when we click on transpose in the Paste Special Dialogue Box, the Paste Link tab disables. I need update of values in destination cells when these change in the source cells. Please help if there is a solution.