Sub copiecellule()
Dim A, B As Worksheet
Dim i As Integer
Set A = Sheets("Risk Log")
Set B = Sheets("Grid")
For i = 6 To 500
If A.Cells(i, 5) = "1" And A.Cells(i, 6) = "1" Then
B.Cells(5, 3) = B.Cells(5, 3) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "1" And A.Cells(i, 6) = "2" Then
B.Cells(5, 4) = B.Cells(5, 4) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "1" And A.Cells(i, 6) = "3" Then
B.Cells(5, 5) = B.Cells(5, 5) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "1" And A.Cells(i, 6) = "4" Then
B.Cells(5, 6) = B.Cells(5, 6) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "1" And A.Cells(i, 6) = "5" Then
B.Cells(5, 7) = B.Cells(5, 7) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "2" And A.Cells(i, 6) = "1" Then
B.Cells(4, 3) = B.Cells(4, 3) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "2" And A.Cells(i, 6) = "2" Then
B.Cells(4, 4) = B.Cells(4, 4) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "2" And A.Cells(i, 6) = "3" Then
B.Cells(4, 5) = B.Cells(4, 5) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "2" And A.Cells(i, 6) = "4" Then
B.Cells(4, 6) = B.Cells(4, 6) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "2" And A.Cells(i, 6) = "5" Then
B.Cells(4, 7) = B.Cells(4, 7) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "3" And A.Cells(i, 6) = "1" Then
B.Cells(3, 3) = B.Cells(3, 3) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "3" And A.Cells(i, 6) = "2" Then
B.Cells(3, 4) = B.Cells(3, 4) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "3" And A.Cells(i, 6) = "3" Then
B.Cells(3, 5) = B.Cells(3, 5) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "3" And A.Cells(i, 6) = "4" Then
B.Cells(3, 6) = B.Cells(3, 6) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "3" And A.Cells(i, 6) = "5" Then
B.Cells(3, 7) = B.Cells(3, 7) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "4" And A.Cells(i, 6) = "1" Then
B.Cells(2, 3) = B.Cells(2, 3) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "4" And A.Cells(i, 6) = "2" Then
B.Cells(2, 4) = B.Cells(2, 4) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "4" And A.Cells(i, 6) = "3" Then
B.Cells(2, 5) = B.Cells(2, 5) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "4" And A.Cells(i, 6) = "4" Then
B.Cells(2, 6) = B.Cells(2, 6) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "4" And A.Cells(i, 6) = "5" Then
B.Cells(2, 7) = B.Cells(2, 7) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "5" And A.Cells(i, 6) = "1" Then
B.Cells(1, 3) = B.Cells(1, 3) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "5" And A.Cells(i, 6) = "2" Then
B.Cells(1, 4) = B.Cells(1, 4) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "5" And A.Cells(i, 6) = "3" Then
B.Cells(1, 5) = B.Cells(1, 5) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "5" And A.Cells(i, 6) = "4" Then
B.Cells(1, 6) = B.Cells(1, 6) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
ElseIf A.Cells(i, 5) = "5" And A.Cells(i, 6) = "5" Then
B.Cells(1, 7) = B.Cells(1, 7) & Chr(10) & A.Cells(i, 3) & " " & A.Cells(i, 4)
End If
Next
'If A.Cells(i, 15) = "2" And A.Cells(i, 16) = "**" Then
' B.Cells(n, 3) = B.Cells(n, 3) & Chr(10) & A.Cells(i, 4) & " " & A.Cells(i, 5)
'n = n + 1
End Sub