Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
118
Views
Topic starter
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
Posted : 13/03/2022 6:45 am
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
Posted : 17/03/2022 1:54 am
Topic starter
Hi Catalin Bombea
there is any formula to update in excel with out VB code
Thanks /Saliha
Posted : 17/03/2022 7:18 am
I think the matter is too complex to handle it with excel simple formulas.
Posted : 17/03/2022 11:00 am
