Hi Ninja Team
as per below image, I have caseid will move from pillar to pillar as 1.client comms 2.Account Linkage, 3.FFC 4.CRD
every week caseid will move to other pillar or will be in same pillar ,
based on movement, I will update as comment as not stated , wip and completed
I have only overall Ageing of caseid, I need to update ageing based on movement from last week to this week,
---I have more than 1000's of caseid ,
* if Column as 'Completed' , it should freeze and remaining ageing should add on next wip
** -please help if any way to automate to compare last week file and this week file caseid and update ageing bases on movement.
Here with attached sample file
Below is small code i used to update the pillar's movement - i do no how to compare last week file and this week and update ageing .
please help
as per below image, I have caseid will move from pillar to pillar as 1.client comms 2.Account Linkage, 3.FFC 4.CRD
every week caseid will move to other pillar or will be in same pillar ,
based on movement, I will update as comment as not stated , wip and completed
I have only overall Ageing of caseid, I need to update ageing based on movement from last week to this week,
---I have more than 1000's of caseid ,
* if Column as 'Completed' , it should freeze and remaining ageing should add on next wip
** -please help if any way to automate to compare last week file and this week file caseid and update ageing bases on movement.
Here with attached sample file
Below is small code i used to update the pillar's movement - i do no how to compare last week file and this week and update ageing .
please help
Code:
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Range("C" & i).Value = "Client Comms" Then
If Range("D" & i).Value = "Client Comms" Then
Range("E" & i).Value = "WIP - " & Range("B" & i).Value
Range("F" & i).Value = "_"
Range("G" & i).Value = "-"
Range("H" & i).Value = "-"
Range("I" & i).Value = "Not Started"
End If
End If
NEXT I
Attachments
Last edited by a moderator: