I want to print out the starting Date of the inventory based on inventory quantity using Macro.
Here is my explanation;
Some months don’t produce any inventory(0 or null) but other months can produce
Some inventory. I want to print out the first starting date of the inventory. So we can know
When is the first starting date for the product.
In the file examples, A- the product starts producing in Sep-10, so the result will be 9/1/2010 on D:7
B- The product starts producing in Dec_10, so the result will be 12/1/2010 on D:7
My try out;
Would you help me
Bookmarks