Sub MojeProcedure() Dim strKod_1 As String Dim strKod_2 As String Dim strPopis As String Dim intSloupec As Integer 'Worksheets("Tabulka1").Cells(2, 2).Value = "AHOJ" ' Application.SendKeys "^g ^a {DEL}" For i = 2 To 3464 intSloupec = 2 strKod_1 = Worksheets("Tabulka1").Cells(i, 1).Value Debug.Print strKod_1 For j = 2 To 74439 strKod_2 = Worksheets("Tabulka2").Cells(j, 5).Value If (StrComp(strKod_1, strKod_2, vbTextCompare) = 0) Then strPopis = Worksheets("Tabulka2").Cells(j, 7).Value Worksheets("Tabulka1").Cells(i, intSloupec).Value = strPopis intSloupec = intSloupec + 1 End If Next j Next iEnd Sub