VBA Find Last Point

[ivandgreat]

Dears,

I have a table with Start and End, i would like to have a vba that will look up the Last value based on col Start and End.


[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A001[/TD]
[TD]A002[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A002[/TD]
[TD]A003[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A004[/TD]
[TD]A005[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]A006[/TD]
[TD]A007[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]A005[/TD]
[TD]A006[/TD]
[/TR]
</tbody>[/TABLE]

Output table,

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]m[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]Last[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A001[/TD]
[TD]A002[/TD]
[TD]A003[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A002[/TD]
[TD]A003[/TD]
[TD]A003[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]A004[/TD]
[TD]A005[/TD]
[TD]A007[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]A006[/TD]
[TD]A007[/TD]
[TD]A007[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]A005[/TD]
[TD]A006[/TD]
[TD]A007[/TD]
[/TR]
</tbody>[/TABLE]


br,

 

[MickG]

Please show an example.