Add in column based on specific task

[leanne2011]

Hi

I will be running the same pivot each month and need to add on another due date column to F.
What I need the macro to do is in column E to display the due dates for the specific task "Client data received for payroll processing" and in column F to display the due dates for the specific task "Draft payroll results submitted to the client"

I attach the pivot, the beginning of the code and the results I am hoping to achieve

Many thankstest pivot excel.xlsexpected result.xls

Sub Macro1()
'

    Cells.Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("F4").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "Due  Date"
    Range("F5").Select
End Sub