+ Reply to Thread
Results 1 to 4 of 4

Match part number then extract qty onto a different sheet

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Match part number then extract qty onto a different sheet

    Hi,


    I'm here asking for a little help I have 2 sheets in a file. One is given to me from our parts department containing all parts on a given truck model. The 2nd sheet is exported as a database file from inventor and imported as an update able sheet in excel.

    I am needed to compare part numbers between the 2 sheets and the qty of each. So far I have it where it matches the part numbers and turns the ones I don't have in the model red. Now I'm trying to match the part numbers and pull the qty of said part from sheet 2, the imported one, and compare it to the to the qty in the 1st. All I really need to accomplish is matching the part numbers then copying the qty from sheet 2 to sheet 1 onto a new cell of the matched part number.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    11-11-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Match part number then extract qty onto a different sheet

    Hi Mate.

    You might want to upload your file, or a sample so that we can have a look at what you need to do.

  3. #3
    Registered User
    Join Date
    04-03-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Match part number then extract qty onto a different sheet

    I'm mobile right at the moment but I will post an example as soon as I get by a computer

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Match part number then extract qty onto a different sheet

    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to extract part of a cell that's an alphanumeric (minus sign with number/alpha value)
    By Jaybo7273 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2013, 09:47 AM
  2. Match 2 lists based on Part Number
    By jamezgreen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2012, 01:59 PM
  3. match columns and find the matched Part number
    By rajivs27 in forum Excel General
    Replies: 5
    Last Post: 02-17-2010, 04:46 PM
  4. Extract just numeric part of mixed text/number entry?
    By Heidi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-01-2006, 02:35 PM
  5. Can Index & Match find a paticular part number
    By vane0326 in forum Excel General
    Replies: 0
    Last Post: 02-03-2005, 07:56 PM

Tags for this Thread

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