Test runs from code
Code:
Sub TestyCalls() ' http://www.excelfox.com/forum/showthread.php/2277-Vba-button-Comparison-data-between-two-file-or-two-tabs?p=10741#post10741
' Call Testie(Worksheets("Sheet1"), Worksheets("Sheet2"))
 Call Testy(Worksheets("Sheet1"), Worksheets("Sheet2"))
End Sub

For support of this excelfox Thread:
http://www.excelfox.com/forum/showth...0741#post10741

Using Excel 2007 32 bit
Sheet1 Sheet1 Test Output Test Output Sheet2 Sheet2
Customer Assembly Customer Assembly
Nu Torque
13456
 Nu Torque
13456
Blu Origin Spaceship Blu Origin Spaceship
Jet Blue21 ABC
Alaska
789
Toyota Supra
Emirate ABC12345
Jet Blue21 ABC
Alaska
789
Toyota Supra
Emirate ABC12345
Dup 2 of Toyota Dup 2 of Supra Toyota Supra
Dup 2 of Emirate Dup 2 of ABC12345 Emirate ABC12345
Spaceship 12 Spaceship
12
Worksheet: Tabelle3


Using Excel 2007 32 bit
Sheet1 Sheet1 Test Output Test Output Sheet2 Sheet2
Customer Assembly Customer Assembly
Nu Torque
13456
 Nu Torque
13456
Blu Origin Spaceship Alaska
789
Jet Blue21 ABC Excel123 HiThai Excel123 HiThai
Alaska
789
 Blu Origin Spaceship
Toyota Supra Emirate ABC12345
Emirate ABC12345 Jet Blue21 ABC
Toyota Supra
Worksheet: Tabelle3