VBA How to multiple data based of identifcation # and date

[FranticIntern]

ID #	date	price	(after code)	ID #	Date	Factor
001	1/1	5	5	001	1/3	2
001	1/2	5	5	002	1/5	3
001	1/3	10	= 5 (Price) * 2(Factor)
001	1/4	10	=5 (Price) * 2(Factor)
001	1/5	10	= 5 (Price) * 2(Factor)
001	...	10	= 5 (Price) * 2(Factor)
001	1/10	10	= 5 (Price) * 2(Factor)
002	1/1	4
002	1/2	4
002	1/3	4
002	1/4	4
002	1/5	12	= 4(price) * 3 (factor)
002	1/6	12	= 4(price) * 3 (factor)
002	...	12	= 4(price) * 3 (factor)
002	1/10	12	= 4(price) * 3 (factor)

<tbody>
</tbody>

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.