Projects and milestones / sequential numbers and different formulas in your rows

[WhiteMagnus]

Hi,

I have been trying to automized this board, the idea being to be able to add a row Project 2 underneath with possibility to add milestones as well.
Every data written in RED should be added manually, the rest in GREEN should be automized.
The main row for Project is pretty much and averagea of the milestones information.
Also, the task NUMBERS should also be added automatically if possible,

I know the formulas for my basic Projects average, but I do not know how to make that board automatic,
Kinda new with excel but Im sure I will understand

Thanks in advance

 

[James006]

Hi,
For Column A, your Task Number, you can test

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column <> 1 Then Exit Sub
Dim ar As Variant
    If InStr(1, Target.Offset(-1, 0), ".") Then
        ar = Split(Target.Offset(-1, 0), ".")
        Target = ar(0) & "." & ar(1) + 1
    Else
        Target = Target.Offset(-1, 0) & "." & "1"
    End If
Cancel = True
End Sub

 

[WhiteMagnus]

Hi,
For Column A, your Task Number, you can test

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column <> 1 Then Exit Sub
Dim ar As Variant
    If InStr(1, Target.Offset(-1, 0), ".") Then
        ar = Split(Target.Offset(-1, 0), ".")
        Target = ar(0) & "." & ar(1) + 1
    Else
        Target = Target.Offset(-1, 0) & "." & "1"
    End If
Cancel = True
End Sub

Thanks, I try right away