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

Product	Volume	reached 500	2000	etc
A	100	date	date
B	500	date	date
C	1500	date	date
D	3000	date	date

<tbody>
</tbody>

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!