Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default need to paste link from 4 vertical cells to 4 horizontal cells?

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default need to paste link from 4 vertical cells to 4 horizontal cells?

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default need to paste link from 4 vertical cells to 4 horizontal cells

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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default need to paste link from 4 vertical cells to 4 horizontal cells

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?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default need to paste link from 4 vertical cells to 4 horizontal cells

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?





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default need to paste link from 4 vertical cells to 4 horizontal cells

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?




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default need to paste link from 4 vertical cells to 4 horizontal cells

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link horizontal cells vertically? Brett Excel Discussion (Misc queries) 3 January 4th 06 05:49 AM
Linking a horizontal set of cells to a vertical sets of cells Russell-stanely Charts and Charting in Excel 2 October 21st 05 03:19 PM
copy & paste spreadsheet cells from excel to outlook to excel mismarple Excel Discussion (Misc queries) 1 September 20th 05 11:16 PM
Paste Link Freshman Excel Worksheet Functions 7 August 29th 05 02:00 PM
Paste link versus allowing two cells equal each other? emerb Excel Discussion (Misc queries) 5 January 4th 05 05:42 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"