+ Reply to Thread
Results 1 to 11 of 11

Quick and easy

  1. #1
    db
    Guest

    RE: Quick and easy

    Just add a plus sign inbetween each reference:

    ='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book
    placements recovery301.xls]Sheet1'!$G$776

    ---
    Regards,
    db


    "chisigs2" wrote:

    > I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
    >
    >
    > I know this is easy but i cant think....
    >
    > I am trying to add 2 different cells from one workbook to 1 cell in
    > another workbook linked.... Someone make me realize that i need to give
    > up and get some sleep.....
    >
    > ='[client book placements recovery301.xls]Sheet1'!$G$720
    > ='[client book placements recovery301.xls]Sheet1'!$G$776
    >
    > Those are the 2 cells that i am trying to add via a link to another
    > page as you can see.
    >
    > Thanks... Send Starbucks my WAY
    >
    >


  2. #2
    chisigs2
    Guest

    Re: Quick and easy

    Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
    come up with that...

    Chris


  3. #3
    db
    Guest

    RE: Quick and easy

    Just add a plus sign inbetween each reference:

    ='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book
    placements recovery301.xls]Sheet1'!$G$776

    ---
    Regards,
    db


    "chisigs2" wrote:

    > I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
    >
    >
    > I know this is easy but i cant think....
    >
    > I am trying to add 2 different cells from one workbook to 1 cell in
    > another workbook linked.... Someone make me realize that i need to give
    > up and get some sleep.....
    >
    > ='[client book placements recovery301.xls]Sheet1'!$G$720
    > ='[client book placements recovery301.xls]Sheet1'!$G$776
    >
    > Those are the 2 cells that i am trying to add via a link to another
    > page as you can see.
    >
    > Thanks... Send Starbucks my WAY
    >
    >


  4. #4
    chisigs2
    Guest

    Re: Quick and easy

    Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
    come up with that...

    Chris


  5. #5
    db
    Guest

    RE: Quick and easy

    Just add a plus sign inbetween each reference:

    ='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book
    placements recovery301.xls]Sheet1'!$G$776

    ---
    Regards,
    db


    "chisigs2" wrote:

    > I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
    >
    >
    > I know this is easy but i cant think....
    >
    > I am trying to add 2 different cells from one workbook to 1 cell in
    > another workbook linked.... Someone make me realize that i need to give
    > up and get some sleep.....
    >
    > ='[client book placements recovery301.xls]Sheet1'!$G$720
    > ='[client book placements recovery301.xls]Sheet1'!$G$776
    >
    > Those are the 2 cells that i am trying to add via a link to another
    > page as you can see.
    >
    > Thanks... Send Starbucks my WAY
    >
    >


  6. #6
    chisigs2
    Guest

    Re: Quick and easy

    Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
    come up with that...

    Chris


  7. #7
    db
    Guest

    RE: Quick and easy

    Just add a plus sign inbetween each reference:

    ='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book
    placements recovery301.xls]Sheet1'!$G$776

    ---
    Regards,
    db


    "chisigs2" wrote:

    > I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
    >
    >
    > I know this is easy but i cant think....
    >
    > I am trying to add 2 different cells from one workbook to 1 cell in
    > another workbook linked.... Someone make me realize that i need to give
    > up and get some sleep.....
    >
    > ='[client book placements recovery301.xls]Sheet1'!$G$720
    > ='[client book placements recovery301.xls]Sheet1'!$G$776
    >
    > Those are the 2 cells that i am trying to add via a link to another
    > page as you can see.
    >
    > Thanks... Send Starbucks my WAY
    >
    >


  8. #8
    chisigs2
    Guest

    Re: Quick and easy

    Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
    come up with that...

    Chris


  9. #9
    chisigs2
    Guest

    Quick and easy

    I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....


    I know this is easy but i cant think....

    I am trying to add 2 different cells from one workbook to 1 cell in
    another workbook linked.... Someone make me realize that i need to give
    up and get some sleep.....

    ='[client book placements recovery301.xls]Sheet1'!$G$720
    ='[client book placements recovery301.xls]Sheet1'!$G$776

    Those are the 2 cells that i am trying to add via a link to another
    page as you can see.

    Thanks... Send Starbucks my WAY


  10. #10
    db
    Guest

    RE: Quick and easy

    Just add a plus sign inbetween each reference:

    ='[client book placements recovery301.xls]Sheet1'!$G$720 + '[client book
    placements recovery301.xls]Sheet1'!$G$776

    ---
    Regards,
    db


    "chisigs2" wrote:

    > I am going on about 5 hrs sleep in the last 48 hrs so bare with me.....
    >
    >
    > I know this is easy but i cant think....
    >
    > I am trying to add 2 different cells from one workbook to 1 cell in
    > another workbook linked.... Someone make me realize that i need to give
    > up and get some sleep.....
    >
    > ='[client book placements recovery301.xls]Sheet1'!$G$720
    > ='[client book placements recovery301.xls]Sheet1'!$G$776
    >
    > Those are the 2 cells that i am trying to add via a link to another
    > page as you can see.
    >
    > Thanks... Send Starbucks my WAY
    >
    >


  11. #11
    chisigs2
    Guest

    Re: Quick and easy

    Thanks..... that works great..... The IDIOTS on MREXCEL.COM couldnt
    come up with that...

    Chris


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1