Hello to All, I'm writing from Italy;
This is my first post on this forum, using Excel since long time but not expert on VBA..<o></o>
This is my issue:<o></o>
During follow up of my team activity job, I use one list of problem we are working on, day by day;<o></o>
Each row contains one single problem.<o></o>
Each column contains data (many) related to the problem (problem name, when received, who is in charge etc.)<o></o>
<o></o>
One of the column contains “step” of problem (for example “waiting sample”, “checking sample”, “making test”, etc).<o></o>
We have with team weekly followup of activity, updating the status of each problem according to real progress.<o></o>
<o></o>
What I would like to have (also to investigate bottleneck at the end of activity) is a way to “count” days we spent in any step of activity (please consider that sometimes we change status more than one time on the single “step”, for ex we can have “checking sample” à “making test” à “checking sample”…<o></o>
<o></o>
So, I’m considering to have inside my sheet, some additional column with label to represent each step (for ex: waiting sample,checking sample,making investigation,making test …) and in the correspondant row of each problem it should be the number of days spent for each step<o></o>
<o></o>
How to do?<o></o>
Basically I think it should be some function registering the date when the status of "step cell" has been modified (counting how many days past since previous modification)and putting result (number of days) in the correspondent cell of each step time spent, adding to the previous number of days if different from 0…<o></o>
<o></o>
Easy to say…but how to realize?<o></o>
This is my first post on this forum, using Excel since long time but not expert on VBA..<o></o>
This is my issue:<o></o>
During follow up of my team activity job, I use one list of problem we are working on, day by day;<o></o>
Each row contains one single problem.<o></o>
Each column contains data (many) related to the problem (problem name, when received, who is in charge etc.)<o></o>
<o></o>
One of the column contains “step” of problem (for example “waiting sample”, “checking sample”, “making test”, etc).<o></o>
We have with team weekly followup of activity, updating the status of each problem according to real progress.<o></o>
<o></o>
What I would like to have (also to investigate bottleneck at the end of activity) is a way to “count” days we spent in any step of activity (please consider that sometimes we change status more than one time on the single “step”, for ex we can have “checking sample” à “making test” à “checking sample”…<o></o>
<o></o>
So, I’m considering to have inside my sheet, some additional column with label to represent each step (for ex: waiting sample,checking sample,making investigation,making test …) and in the correspondant row of each problem it should be the number of days spent for each step<o></o>
<o></o>
How to do?<o></o>
Basically I think it should be some function registering the date when the status of "step cell" has been modified (counting how many days past since previous modification)and putting result (number of days) in the correspondent cell of each step time spent, adding to the previous number of days if different from 0…<o></o>
<o></o>
Easy to say…but how to realize?<o></o>