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?

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?

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?

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cioangel" wrote in message
...
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?

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.

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cioangel" wrote in message
...
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?

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cioangel" wrote in message
...
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.

"Ragdyer" wrote:

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.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"cioangel" wrote in message
...
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?

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.

"Ragdyer" wrote:

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cioangel" wrote in message
...
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.

"Ragdyer" wrote:

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.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"cioangel" wrote in message
...
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?