+ Reply to Thread
Results 1 to 6 of 6

Assistance in Linking Cells into Several Worksheet

  1. 02-11-2015, 02:36 AM #1
    shuriyan0924
    shuriyan0924 is offline
    Registered User
    Join Date
    01-15-2015
    Location
    Malaysia
    MS-Off Ver
    MS 2010
    Posts
    15

    Assistance in Linking Cells into Several Worksheet

    hey guys..

    Need all the help i can to solve my problem.. i attached together a sample of my workbook.

    FULL PRICE LIST-Sample.xlsx

    Okay, here is the result i am looking for ; This quotation sheet PRICE/UNIT cells must be able to return correct value by matching the COMPANY and IMPA NUMBER

    **COMPANY [Cell C4]-- is a dropdown list which consist of several companies names as AMOS,ANCHOR,etc ( as u can see in sub sheets beside the FULL LIST)
    **IMPA NUMBER [Column C] -- is where we key in the product code

    So the challenge for me is how to link PRICE/UNIT with several different sheets of company names and yet still manage to return the value by chosen company.
    Really appreciate it if you guys can help up..

    cheers!!!

    Shuriyan
    Reply With QuoteRegister To Reply
  2. 02-11-2015, 02:53 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Assistance in Linking Cells into Several Worksheet

    1st, make sure ALL your headings are IDENTICAL. Quotation sheet says ITEM NAME, the others just say ITEM - correct that.

    Then use this, copied down and across...
    =IFERROR(INDEX(INDIRECT("'"&$C$4&"'!C6:M27"),MATCH($C11,INDIRECT("'"&$C$4&"'!B6:B27"),0),MATCH(D$10,INDIRECT("'"&$C$4&"'!C5:M5"),0)),"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-11-2015, 03:57 AM #3
    shuriyan0924
    shuriyan0924 is offline
    Registered User
    Join Date
    01-15-2015
    Location
    Malaysia
    MS-Off Ver
    MS 2010
    Posts
    15

    Re: Assistance in Linking Cells into Several Worksheet

    hi there FDibbins... thanx for the fast respond.. bro i tried and change and make sure all use the same heading.. and i copied the formula into G11 and across... but the result return as the description of the item.. is there anywhere i did wrong? thanx
    Reply With QuoteRegister To Reply
  4. 02-11-2015, 09:34 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Assistance in Linking Cells into Several Worksheet

    An alternative...
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  5. 02-11-2015, 09:59 AM #5
    shuriyan0924
    shuriyan0924 is offline
    Registered User
    Join Date
    01-15-2015
    Location
    Malaysia
    MS-Off Ver
    MS 2010
    Posts
    15

    Re: Assistance in Linking Cells into Several Worksheet

    Quote Originally Posted by Glenn Kennedy View Post
    An alternative...
    hey there buddy... thanx alot.. that juz exactly what i wanna it to be...
    Reply With QuoteRegister To Reply
  6. 02-11-2015, 10:01 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Assistance in Linking Cells into Several Worksheet

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking/unlinking chart Assistance Please
    By jam320 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-25-2014, 05:59 PM
  2. Excel 2007 : Need suggestions on linking a range of cells from one worksheet to another worksheet.
    By tykomusic in forum Excel General
    Replies: 1
    Last Post: 03-27-2012, 03:25 PM
  3. [SOLVED] Linking cells by name only to another worksheet....
    By Jkralick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2006, 09:10 PM
  4. Need assistance linking workbooks by date
    By bsmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2005, 04:30 PM
  5. [SOLVED] Assistance with linking please...
    By Tom Bradstreet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 05:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1