+ Reply to Thread
Results 1 to 5 of 5

Macro Pulling Part Numbers?

  1. 06-20-2018, 04:55 PM #1
    devinNetzelMP
    devinNetzelMP is offline
    Registered User
    Join Date
    06-20-2018
    Location
    Chicago, Illinois
    MS-Off Ver
    2010
    Posts
    2

    Macro Pulling Part Numbers?

    Okay So, I have a BOM, in a pretty standard format where it lists all the Designators, for the specific Part number. I am making a Pick and Place File, in which all of the Designators are Separate. I need the Part Number for Each Designator. Is there a Macro that can pull, the Part Number from the BOM, and list it for each designator.



    IE:

    C1, C2, C3, C4, C5, C6, PART NUMBER 1
    C7, C8, C9, PART NUMBER 2


    INTO


    C1 PART NUMBER 1
    C2 PART NUMBER 1
    C3 PART NUMBER 1
    C4 PART NUMBER 1
    C5 PART NUMBER 1
    C6 PART NUMBER 1
    C7 PART NUMBER 2
    C8 PART NUMBER 2
    C9 PART NUMBER 2
    Reply With QuoteRegister To Reply
  2. 06-20-2018, 05:22 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Macro Pulling Part Numbers?

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 06-21-2018, 12:10 PM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Macro Pulling Part Numbers?

    Hi devinNetzelMP

    Welcome to the forum...Perhaps someone else can simplify...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 06-21-2018, 01:36 PM #4
    devinNetzelMP
    devinNetzelMP is offline
    Registered User
    Join Date
    06-20-2018
    Location
    Chicago, Illinois
    MS-Off Ver
    2010
    Posts
    2

    Re: Macro Pulling Part Numbers?

    That worked Magically! And I tested it on a BOM with 350 Designators. This is a total life saver! Thank you!
    Reply With QuoteRegister To Reply
  5. 06-21-2018, 01:52 PM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Macro Pulling Part Numbers?

    Glad I could help...If that solves your initial query then please mark thread as solved...Top of thread..[Thread Tools]
    Tx for rep added
    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. Pulling a value from a sheet with multiple possible part numbers.
    By Mr_Phil in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2015, 10:41 PM
  2. [SOLVED] Macro to Display the Top 5 Most Frequently Occurring Part Numbers
    By Hackboss007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 03:15 PM
  3. Macro VLOOKUP needed - fetching data from part numbers
    By gotze in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-25-2013, 09:09 AM
  4. VBA? Formula for pulling multiple dates for one part. Please help
    By bernice620 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2012, 11:23 AM
  5. Matching ID numbers and pulling data via macro
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2011, 08:01 AM
  6. Macro for returning cell info after pulling numbers from web
    By DrSues02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2009, 02:56 PM
  7. Pulling Apart Rows - Part 2
    By paul_20k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2006, 09:55 AM

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