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

G

Guest

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

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top