test results from code above, ( http://www.excelfox.com/forum/showth...0762#post10762 ) in support of this post:
http://www.excelfox.com/forum/showth...0764#post10764
Using Excel 2007 32 bit
Worksheet: Result
Row\Col Original Original Original Original Original Original 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 ABC 458 458 < > 2 Jet Blue23 ABC DEF DEF Jet Blue23 ABC DEF DEF EXCELL123 ABC ABC EXCELL123 ABC ABC Toyota Supra Toyota Supra Emirate ABC12345 Emirate ABC12345 Angel ABC12346 MISSING: 1 Angel ABC12346 462 462 Jet Blue21 ABC
Using Excel 2007 32 bit
Worksheet: Result
Original Original Original Original Original Original 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 ABC 458 458 < > 2 Jet Blue23 ABC DEF DEF Jet Blue23 ABC DEF DEF EXCELL123 ABC ABC EXCELL123 ABC ABC Toyota Supra Toyota Supra Emirate ABC12345 Emirate ABC12345 Angel ABC12346 MISSING: 1 Angel ABC12346 462 462 Jet Blue21 ABC
Using Excel 2007 32 bit
Worksheet: Result
Row\Col Test Output 2 Jet Blue21 ABC 458 458 < > 2 Jet Blue23 ABC DEF DEF MISSING: 1 Angel ABC12346 462 462
Reply With Quote
Bookmarks