ciao
da inserire nel modulo del foglio
Option Explicit
Sub NuvoleSole()
Dim Uriga As Long, i As Long
Uriga = UsedRange.Row + UsedRange.Rows.Count
''
Range("J4:J" & Uriga).ClearContents
For i = 4 To Uriga
If Cells(i, "E") > 0 Then
If Cells(i, "E") Mod 2 = 0 Then
If Cells(i, "E") >= Cells(1, "A") Then
Cells(i, "J") = Cells(2, "N")
End If
End If
Else
If Application.CountIf(Range("E4:E" & Uriga), Cells(i, "B")) > 0 Then
Cells(i, "J") = Cells(2, "P")
End If
End If
Next i
End Sub
Ciao da locate
excel 2007 / 13