VBA How to multiple data based of identifcation # and date

[FranticIntern]

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID #[/TD]
[TD]date[/TD]
[TD]price[/TD]
[TD](after code)[/TD]
[TD]ID #[/TD]
[TD]Date[/TD]
[TD]Factor[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]001[/TD]
[TD]1/3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/2[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]002[/TD]
[TD]1/5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/3[/TD]
[TD]10[/TD]
[TD]= 5 (Price) * 2(Factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/4[/TD]
[TD]10[/TD]
[TD]=5 (Price) * 2(Factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/5[/TD]
[TD]10[/TD]
[TD]= 5 (Price) * 2(Factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]...[/TD]
[TD]10[/TD]
[TD]= 5 (Price) * 2(Factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]1/10[/TD]
[TD]10[/TD]
[TD]= 5 (Price) * 2(Factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/1[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/2[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/3[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/4[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/5[/TD]
[TD]12[/TD]
[TD] = 4(price) * 3 (factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/6[/TD]
[TD]12[/TD]
[TD]= 4(price) * 3 (factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]...[/TD]
[TD]12[/TD]
[TD]= 4(price) * 3 (factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]1/10[/TD]
[TD]12[/TD]
[TD]= 4(price) * 3 (factor)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to code so that I can match up ID # and Dates and multiply the price with its factor all the way to its last date.

Much help is appreciated, if you have any questions please ask and I will get back to you promptly.