Sample test results for code from last post ( http://www.excelfox.com/forum/showth...0758#post10758 )

Using Excel 2007 32 bit
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
1
 Nu Torque
13456
456
456
1
 Nu Torque
13456
456
456
1
 Blu Origin Spaceship
457
457
1
 Blu Origin Spaceship
457
457
2
 Jet Blue21 ABC
458
458
 2 Jet Blue21 < > Jet Blue23 ABC 458 < > DEF 458 < > DEF
2
 Jet Blue23 ABC DEF DEF
3
 EXCELL123
123
 ABC ABC
3
 EXCELL123
123
 ABC ABC
3
 Toyota Supra
460
460
3
 Toyota Supra
460
460
2
 Emirate ABC12345
461
461
2
 Emirate ABC12345
461
461
1
 Angel ABC12346
462
462
 MISSING: 1 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462
2
 Jet Blue21 ABC
458
458
Worksheet: Result


Using Excel 2007 32 bit
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
Worksheet: Result