Nested Loops due to multiple rows with same ID

[t3chg1rl]

Hi,
I've got an excel sheet that looks like this more or less:

ID	Title	Desc	Revision	Status	Date Changed
1	Excel Problem	Need help	1	New	12/1/16
1	Excel Problem	I need help	2	New	12/2/16
1	Excel Problem	I need help	3	Approved	12/4/16
1	Excel Problem	Better desc of problem	4	Approved	12/5/16
1	Excel Problem	Better desc of problem	5	Closed	12/6/16
2	Another Problem	So many questions	1	New	12/3/16

So basically I am tracking the day that the status changes, and I am trying to get the amount of time between when each item was approved and closed. Which if those items were on the same row or in the same location all the time I could get that, but since I am needing to look at seeing for each ID, what is the first occurrence of "Approved" status and what was the Date Changed for that row, and then also see the same for "Closed" and do that for every ID. So I think I need to loop through the IDs, and loop when I hit a new ID. But I'm not sure how to do that when you can see that due to the fact that each item has been revised - updated description or whatever, the status may be Approved multiple times, and I just need the first time. And I guess I need to write all this to a new worksheet - something like ID - Title - Approved Date - Closed Date - DateDiff. So I am also condensing from having multiple rows with the same ID to just having one row with the relevant data.

Any help or even just suggestions of the direction to go would be greatly appreciated! I have been trying to google and get bits of VBA code here and there, but I am not sure what kind of loops or how to nest them? Thank you!!!!!!!!!!!

[protonLeah]

title updated, thanks...

[t3chg1rl]

I have changed the title but I'm not really sure what was wrong with my title? I don't know what kind of nested loops I need help with, it's kind of hard to make it more accurate? Thanks