Sample test results for code from last post ( http://www.excelfox.com/forum/showth...0758#post10758 )
Using Excel 2007 32 bit
Worksheet: Result
Original Original Original Original Original Original Test Output Test Output Test Output Test Output Test Output NEW NEW NEW NEW NEW NEW Assembly #: Assembly Name: Assembly #: Assembly Name: Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN Nu Torque Nu Torque Blu Origin Spaceship Blu Origin Spaceship Jet Blue21 ABC 2 Jet Blue21 < > Jet Blue23 ABC 458 < > DEF 458 < > DEF Jet Blue23 ABC DEF DEF EXCELL123 ABC ABC EXCELL123 ABC ABC Toyota Supra Toyota Supra Emirate ABC12345 Emirate ABC12345 Angel ABC12346 MISSING: 1 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462 Jet Blue21 ABC
Using Excel 2007 32 bit
Worksheet: Result
Test Output Test Output Test Output Test Output Test Output 2 Jet Blue21 < > Jet Blue23 ABC 458 < > DEF 458 < > DEF MISSING: 1 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462
Reply With Quote
Bookmarks