I need a help on distribution function

Hi friends,

Attached an excel. I need to distribute the target ("T") in each date automatically for each product as per maximum quantity ("I").

Once the target change it need to balance as per the date.

Manually i typed in a few cells in V3 etc.

Please kindly help.

Regards,
Attachment 429258

Vishnu