Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Spreeadsheets

    Working with 2 workbooks (2nd tried)

    Hi melone, The reason I don't want to use VLOOKUP as I already mention 3- How the VBA can search like a wildcard ?? If in my BOM have a part 74HC00, I want the VBA can retreive all possile parts in database as 74HC00A, 74HC00AN etc... Even VLOOKUP, INDEX and MATCH doesn't doing good job for...
  2. Spreeadsheets

    Working with 2 workbooks (2nd tried)

    Dear all, I'm very new in VBA.I've been running on too little sleep and too much panic which has probably been the cause of my frantic cries for help on here. I have a question about using 2 workbooks. Worbook1 (activeworkbook)is my BOM. Worbook2 is my database. The logic is: Book1: If colE...
  3. Spreeadsheets

    Retreive data from different workbooks

    Dear all, I'm very new in VBA.I've been running on too little sleep and too much panic which has probably been the cause of my frantic cries for help on here. I have a question about using 2 workbooks. Worbook1 (activeworkbook)is my BOM. Worbook2 is my database. The logic is: Book1: If colE...

Part and Inventory Search