I need to find the sum of adjacent data in a column using vba. If it helps, the reason I need to do this is to calculate rework time. If you look at the file attached, the red cells are what is considered rework. When a job leaves a stage and ends up coming back to it, that would be considered rework and I need to find exactly how much time it spends there.
I had an idea to use multiple loops inside each other but that ended up taking decades and not returning my desired result. I am fairly new to VB and I am not sure if there is a way to take the sum of the first adjacent data set in a column. Then I would take the total hours minus that sum to get rework hours. Thanks in advanced!Sample.xls