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
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
1
 Original Original Original Original Original Original Test Output NEW NEW NEW NEW NEW NEW
2
 Assembly #: Assembly Name: Assembly #: Assembly Name:
3
 Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN
4
1
 Nu Torque
13456
456
456
1
 Nu Torque
13456
456
456
5
1
 Blu Origin Spaceship
457
457
1
 Blu Origin Spaceship
457
457
6
2
 Jet Blue21 ABC
458
458
 2 Jet Blue21 ABC 458 458 < > 2 Jet Blue23 ABC DEF DEF
2
 Jet Blue23 ABC DEF DEF
7
3
 EXCELL123
123
 ABC ABC
3
 EXCELL123
123
 ABC ABC
8
3
 Toyota Supra
460
460
3
 Toyota Supra
460
460
9
2
 Emirate ABC12345
461
461
2
 Emirate ABC12345
461
461
10
1
 Angel ABC12346
462
462
 MISSING: 1 Angel ABC12346 462 462
2
 Jet Blue21 ABC
458
458
Worksheet: Result

Using Excel 2007 32 bit
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
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 ABC 458 458 < > 2 Jet Blue23 ABC DEF 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 Angel ABC12346 462 462
2
 Jet Blue21 ABC
458
458
Worksheet: Result


Using Excel 2007 32 bit
Row\Col
G
1
 Test Output
2
3
4
5
6
 2 Jet Blue21 ABC 458 458 < > 2 Jet Blue23 ABC DEF DEF
7
8
9
10
 MISSING: 1 Angel ABC12346 462 462
Worksheet: Result