+ Reply to Thread
Results 1 to 6 of 6

Fill Multi cells in Row if column match both worksheets

  1. #1
    Registered User
    Join Date
    10-23-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    75

    Question Fill Multi cells in Row if column match both worksheets

    Hello,

    Two workbooks....

    I have an exported Excel worksheet1 from the parts database get every Friday. We get RFQ of parts list each week from multi customers about 3000+ parts as they send in MSword, MSoutlook or MSexcel to me I make into Excel worksheet2.
    I do not like to type in every part into the parts software I have my words for that software Cough Cough. The exported excel speadsheet tells the part numbers, Location, Qty, Price, ETC
    I would like to take the Excel RFQ list and have it populated from the other speadsheet

    SAMPLE
    A1 PART number that on both spreadsheet
    A2 QTY on both there request and our stock
    A3 Price
    A4 Location

    So want a compare worksheet1 with worksheet2
    A1 = A* the populate A2-A4 with worksheet1 data

    MB
    Attached Files Attached Files
    Last edited by MBCMDR; 11-07-2009 at 09:34 PM. Reason: Added sample files

  2. #2
    Registered User
    Join Date
    10-23-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    75

    Re: Fill Multi cells in Row if column match both worksheets

    No one has any type of solution? WOW

    MB

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Fill Multi cells in Row if column match both worksheets

    Hello MBCMDR,

    You will get more interest and responses if you post your workbooks in Excel 2003 format.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    10-23-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    75

    Re: Fill Multi cells in Row if column match both worksheets

    Please see the attached MSExcel 2003 sample version of the sheets.

    I now know need these really bad as a customer cam to us with a parts list of 9000 parts saying this was his last year puchases and like to know what we can supply for 2010.

    9000 parts wopuld take me a week to stock check each as stock software only allow 1 part per look up..

    MB
    Attached Files Attached Files

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Fill Multi cells in Row if column match both worksheets

    Hi MBCMDR
    If I understood your issue, I believe the following code does what you wish.
    Please Login or Register  to view this content.
    The code is in the attached workbook RFQ LIST and runs from a button. The file names are hard coded and assumes both are open but that's easily changed. Let me know if you have any issues.
    John
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  6. #6
    Registered User
    Join Date
    10-23-2009
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    75

    Re: Fill Multi cells in Row if column match both worksheets

    Thank you very much as works great...
    I will tweak a bit as adding a popup box to select the workbooks..

    MB

+ 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