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


Please Login or Register  to view this content.