+ Reply to Thread
Results 1 to 8 of 8

linking multiple cells to 1 cell

  1. #1
    Registered User
    Join Date
    06-28-2008
    Location
    bombay
    Posts
    4

    linking multiple cells to 1 cell

    hi i am using excel 2003 i want to link multiple cells from sheet 2 to 1 cell in sheet1 so that when that data entered in sheet2 cells is changed accordingly in sheet1 cell keeping in mind the data is not deleted in sheet2 cells...please suggest thank you...

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day and welcome to the forum,

    Try this

    =Sheet2!A1&Sheet!B1

    If a space is needed

    =Sheet2!A1&" "&Sheet!B1

    Hope this helps
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    06-28-2008
    Location
    bombay
    Posts
    4
    Quote Originally Posted by ratcat
    G'day and welcome to the forum,

    Try this

    =Sheet2!A1&Sheet!B1

    If a space is needed

    =Sheet2!A1&" "&Sheet!B1

    Hope this helps
    hey thanx for the reply but i want the data to change in sheet1 as i enter data to a single cell in sheet2 not stay there in sheet1
    Last edited by sohilbhai; 06-28-2008 at 03:48 AM.

  4. #4
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    Please upload a small example and will go from there.

    I'm unclear of what your results your after.

    Thanks

  5. #5
    Registered User
    Join Date
    06-28-2008
    Location
    bombay
    Posts
    4
    [QUOTE=ratcat]Please upload a small example and will go from there.

    I'm unclear of what your results your after.

    Thanks
    here dwnld the attachment
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day sohilbhai,

    Thanks for the attachment.

    After viewing the attachment, it seems that the cell you want from 'Sheet 2' will move according to other entries, like different month of the year and the Put Sell and the Call Sell.

    I've used the Index and Match formula.

    All you need to do is enter your raw data into 'Sheet 2' then on 'Sheet 1' change cells E1, C2, C3, and C5 to the information your looking for, then the information on 'Sheet 2' will appear in cells E2, E3, and E5.

    Hope this helps

    Please post if more help is needed
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-28-2008
    Location
    bombay
    Posts
    4
    Quote Originally Posted by ratcat
    G'day sohilbhai,

    Thanks for the attachment.

    After viewing the attachment, it seems that the cell you want from 'Sheet 2' will move according to other entries, like different month of the year and the Put Sell and the Call Sell.

    I've used the Index and Match formula.

    All you need to do is enter your raw data into 'Sheet 2' then on 'Sheet 1' change cells E1, C2, C3, and C5 to the information your looking for, then the information on 'Sheet 2' will appear in cells E2, E3, and E5.

    Hope this helps

    Please post if more help is needed
    hi ratcat thanx for the advice
    but would like to knw how did u go about the index & match formula...thnx
    Last edited by sohilbhai; 06-30-2008 at 12:52 AM.

  8. #8
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day,

    Best explained by the following link

    http://www.datapigtechnologies.com/f...rixlookup.html

+ 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