• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    stock valuation (FIFO based)

    Dear Sir, First of all I am not at all aware of VBA, since my actual file is with huge data I shall not be able to handle, second I clearly mentioned my desired result in my file, if you pls tell what more do you need, I shall again try to explain.
  2. T

    stock valuation (FIFO based)

    Dear Sir, I don't know how should I have to proceed further. Forum Rule : Cross Posting - I apologized for that, what more should I have to do ? After all I can't hold anyone's leg for this Misunderstanding : I mentioned in detail against Mr. AlanSidman's post with an example attached, and I...
  3. T

    stock valuation (FIFO based)

    should I conclude it marked as EXCEL IS FAILED
  4. T

    stock valuation (FIFO based)

    Dear Sir, Thanks for your reply, see there is little misunderstanding. My desired result is not only based on source data, it based on the today's stock also, suppose if today's stock of guava is 150(I3), then in the calculation field (J3 to Q9, Yellow highlighted red font) is changed based on...
  5. T

    stock valuation (FIFO based)

    Dear Sir You are absolutely right, we were needy for the solution, and were not getting solution that's why i told him to post. And for that I apologized. Now tell me for that am I not eligible to get the solution ? If so, I shall not post anything further against this issue
  6. T

    stock valuation (FIFO based)

    Dear Sir You can do anything, you may delete my post also, you may cancel my membership also, but sir my life will not stop, if I don't get a solution that does not mean everything will be stopped. However, for your last query I can say if required / needed I use end number of doctors for my...
  7. T

    stock valuation (FIFO based)

    Yes sir my hubby posted that, I beg apology for that, but pls let me know one thing if I suffer from a disease & I can't get it treated properly by a doctor, shouldn't we go to another doctor ?
  8. T

    stock valuation (FIFO based)

    Dear Sir, i think little misunderstanding, my data is not merge cell type, I need the formula driven result in that form & need not to unmerge
  9. T

    stock valuation (FIFO based)

    Dear Sir, Eagerly awaiting for the solution, requesting you & other readers to help
  10. T

    stock valuation (FIFO based)

    Dear All, The attached file's H1 to Q9 is my existing result, where FRUITS are data validated & Stock Qty is manually entered. Problem is now my result sheet is changed (D13 to J16), where D & E columns are existing figures & others are my desired results which would be formula based. It means...
  11. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Waooooo!!!!!! Just Bang on Sir. I needed this only. Thanks a TON Sir.
  12. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    But result is not coming Sir. I gave a screenshot of your file when I changed criteria data. Even when I am changing fruit then also result is coming wrong. I don't know what am I mistaking.
  13. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Dear Sir, First of all am not an actor, a house wife & an employee, hence if you think it is a monologue, then I feel proud to be an actor as in my country actors earn huge amount. (LOL) Second, I stated multiple times what result I need. I need not any more column or date. Refer post #24. In...
  14. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Dear Sir, I think it's a lost case now.
  15. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    In case of criteria date 21/05/2019 & stock 110 result should come like the following: nothing else
  16. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Dear Sir, I have changed the date & qty but not getting desired result.
  17. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Dear Sir, 1) I am appending a file with more detail in the worksheet. Hope it will help you to understand what I need. 2) I don't know anything about binary file, in case your file helps me, am in dark how can I implement that in other file also. Though it's secondary matter. 3) If you need more...
  18. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Dear Sir, Requesting you please check my file, I need that result only that I highlighted in yellow, if I put Stock 232, date 31-05-19 & fruit apple manually. but not getting sir.
  19. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Sir, Misunderstanding. my desired result is in yellow in my file sir which would be based on the criteria which I highlighted in blue. But in your file it is not reflecting Sir.
  20. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Sir, I had seen your posts, you will rock, that I know.
  21. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Sir, Please figure out something, then I shall request you for any modification if required.
  22. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    As I want to know which invoice, which date, & which supplier's stock is lying on that particular date. From that I can calculate how many qty & how many days stock is lying.
  23. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Sir, You are absolutely right. Green - my purchase history Blue - The Data that I shall put manually (Fruit Name, Date, & Stock Qty) Yellow - is the result that I need. But it would be on FIFO Basis. As you can see that I consumed / sold full qty which was purchased earlier, based on the stock...
  24. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    It would be in the last Row if I put stock 445 manually like this in yellow highlighted Area STOCK DATE 31-05-2019 FRUIT STOCK SUPPLIER INV NO DATE QTY RATE APPLE 445 SOM 35/59 17-05-2019 192 11.5 GK TRADER 15 19-05-2019 252 10 SM 102 43564 1 12
  25. T

    Calculation of Stock Qty, Rate, Supplier based on FIFO

    Sorry, I may couldn't get you. Basic issue I explained, Now I dont know whether it would be done or not. What more can I tell Sir ?
Back
Top