Hi Every one!
can any body help me to get data's from one sheet to another, I have a ERP data's in Export Data sheet, but i need arrival qty based on Item code, with first date of shipment date in outer carton sheet. also need invoice no combine if we get data's from two invoices.
Thanks & Regards Saliha
Hi Saliha,
Is it the FIFO method you are trying to implement?
See the solution here:
https://stackoverflow.com/questions/49715121/fifo-using-excel-formula-or-vba
Or:
https://www.myonlinetraininghub.com/excel-forum/excel/stock-valuation-fifo-calculation-in-excel
Hi Catalin Bombea
there is any formula to update in excel with out VB code
Thanks /Saliha
I think the matter is too complex to handle it with excel simple formulas.