need to paste link from 4 vertical cells to 4 horizontal cells?

C

cioangel

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?
 
C

cioangel

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

Ragdyer

Probably the easiest way to start this is to have *both* WBs open.

This procedure will allow XL to do most of the work for you in creating a
path between WBs.

In the target WB, click in the cell where you wish to start the link range.
Type this in:
=INDEX(
Now, navigate to the source WB and click in the first cell of the original
data range, and drag to include the entire range that you wish to link to.

This makes XL create your path.

Now, click in the formula bar and type in a comma at the end of the
displayed formula.
Then type this in after the comma:

COLUMNS($A:A),ROWS(1:1))

And hit <Enter>.

You should now see the data from the first cell of the source range.

Simply drag this formula across your columns, to copy as needed.

This creates the links that you wanted, AND ... you can now examine the
formulas and duplicate the paths that XL created for you, when and if you
wish to establish additional links between these WBs.
 
C

cioangel

Thank you so very much!! This worked. I would never have solved my problem
without your help. My payroll and tax forms have been saved!! Cioangel.
 
P

Phippsy

Hi

I also want to this and get the formula
=INDEX(Sheet3!M4:M6,COLUMNS($A:A),ROWS(1:1))

The first cell copies correctly but then I fet zeros in the other cells. Any
idea where I am going wrong please.
 
Top