add date once a certain product reaches a certain volume of sales

[tanuxaxaxa]

Hi guys,

I have faced a problem I hope you can help me with

I need to track on which date does a certain product reached a certain volume of sales: 500 units, 1000 units, 2000 units

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Volume[/TD]
[TD]reached 500[/TD]
[TD]2000[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]
100[/TD]
[TD]date[/TD]
[TD]date [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]500[/TD]
[TD]date[/TD]
[TD]date [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1500[/TD]
[TD]date [/TD]
[TD]date [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]3000[/TD]
[TD]date [/TD]
[TD]date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Honestly, I have no clue how to tackle this


Help

 

[tanuxaxaxa]

@ Logit
I don't think your dates will be static which is likely to be important.


@ tanuxaxaxa
If you're open to a VBA macro solution, Hui's suggestion to a question here can be adapted.

In the attached,
P1:S1 are used so volumes have formulas
Volumes are copied to column Z
Z1 has a Sumproduct formula
The worksheet calculation event is used to put in the dates

https://app.box.com/s/h2ez8e6ewsdpiyf69dwqcstgdnhcnltn

Thank you, I will do just that!