Using VBA or Macros to get multiple results

[jarust91]

Hello,

I currently have a table with a couple thousand pieces of data. What I am trying to do is create a formula of some type to know all the corresponding dates to a certain person based on their status.

[TABLE="width: 289"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Status[/TD]
[TD]Last Modified[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]16-Aug[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Scheduled[/TD]
[TD="align: right"]15-Aug[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Exited[/TD]
[TD="align: right"]14-Aug[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]10-Aug[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Reg. Completed[/TD]
[TD="align: right"]4-Aug[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Registration[/TD]
[TD="align: right"]1-Aug[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Unreachable[/TD]
[TD="align: right"]31-Jul[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]31-Jul[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Scheduled[/TD]
[TD="align: right"]29-Jul[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Reg. Completed[/TD]
[TD="align: right"]25-Jul[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Abandoned[/TD]
[TD="align: right"]25-Jul[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Exited[/TD]
[TD="align: right"]15-Jul[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Scheduled[/TD]
[TD="align: right"]15-Jul[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]14-Jul[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]14-Jul[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Scheduled[/TD]
[TD="align: right"]13-Jul[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Completed[/TD]
[TD="align: right"]13-Jul[/TD]
[/TR]
[TR]
[TD]Jimmy Doe[/TD]
[TD]Scheduled[/TD]
[TD="align: right"]10-Jul[/TD]
[/TR]
</tbody>[/TABLE]

This is what the table looks like. I would want to know all the corresponding dates from John Doe when his status is completed. Ideally, I would be able to do this for all of the names.

Any help would be great appreciated.

Thanks,

Jarust91

 

[jarust91]

Sorry this was in reply to "C with no eyes"

 

[C with no eyes]

Yes, near the top find the section that relates to sorting c:c. Modify the order= from xlDescending to xlAscending.