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 )


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9iHOYYpaA bC
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgxuL6YCUckeUIh9hoh4AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg.9h4sd6Vs4qE9h7G-bVm8_-
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=Ugw3nF0C04AGt73H1BB4AaABAg.9h6VhNCM-DZ9h7EqbG23kg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg.9h4sd6Vs4qE9h7KvJXmK 8o
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=Ugw3nF0C04AGt73H1BB4AaABAg.9h6VhNCM-DZ9h7E1gwg4Aq
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgywFtBEpkHDuK55r214AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h79hNGvJ bu
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h79YAfa2 4T
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h79M1SYH 1E
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h78SxhXT nR
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA