Code in support of this Post
http://www.excelfox.com/forum/showth...0745#post10745




Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
1
 Sheet1 Sheet1 Test Output Test Output Sheet2 Sheet2
2
 Customer Assembly Customer Assembly
3
 Nu Torque
13456
 Nu Torque
13456
4
 Blu Origin Spaceship Alaska
789
5
 Jet Blue21 ABC Excel123 HiThai Excel123 HiThai
6
 Alaska
789
 Blu Origin Spaceship
7
 Toyota Supra Missing: Toyota Missing: Supra Emirate ABC12345
8
 Emirate ABC12345 Jet Blue21 ABC
9
Worksheet: Tabelle3