An every day dynamic calculation of how many days we have until we run out of stock according to two given data - future sales (prediction) & quantity in stock TODAY.
Please see the video I attached for better understanding of what's needed:
[login to view URL]
15 pekerja bebas membida secara purata $28 untuk pekerjaan ini
HI, I am good at Excel and VBA. I have referred the requirement. I prefer to write a small VBA Program to get the desired. Looking forward to work on the project and provide quick solution. -Chandra
Hi, I can create a VBA script that will automatically calculate the number of days of stock you have whenever you chandge the date. Best regards, Florin Enache