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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >