In the last code , ( Sub Testies ), the following output is obtained when using the suggested test data above ( http://www.excelfox.com/forum/showth...0756#post10756 ) :


Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
1
 Original Original Original Original Original Original Test Output Test Output Test Output Test Output 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 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 MISSING: Angel MISSING: ABC12346 MISSING: 462 MISSING: 462
2
 Jet Blue21 ABC
458
458
Worksheet: Result


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



Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
1
 Original Original Original Original Original Original Test Output Test Output Test Output Test Output Test Output NEW NEW NEW NEW NEW NEW
6
2
 Jet Blue21 ABC
458
458
 2 Jet Blue23 ABC DEF DEF
2
 Jet Blue23 ABC DEF DEF
Worksheet: Result

_._____________________________________-

We have currently output like this:
Test Output Test Output Test Output Test Output Test Output
2 Jet Blue23 ABC DEF DEF
But We want this to look more similar to screenshot output from post #15 ( http://www.excelfox.com/forum/showth...0754#post10754 )