=SE(D5<>"";H4+1;"attesa dati")
=SE(O6<>"";SOSTITUISCI(S5;STRINGA.ESTRAI(S5;4;3);STRINGA.ESTRAI(S5;4;3)+1);"attesa dati")
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("o:o")) Is Nothing Then If Target = "" Then Exit Sub ElseIf Cells(Target.Row, "S") = "attesa dati" Then Cells(Target.Row - 1, "S").Select num = Split(Cells(Target.Row - 1, "S"), "/") num(1) = Val(num(1)) + 1 Cells(Target.Row, "S") = num(0) & "/" & num(1) & "/" & num(2) Cells(Target.Row + 1, "S") = "attesa dati" End If End If End Sub