+ 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 Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,892

    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)

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