Inventory management

[kabirr]

I use excel for inventory management but every i have copy paste items with their code in row on another sheet, which is manual and many times get stuck with mismatching
item codes ending in stock errors. Used sumifs formula but the sheets list is increasing on daily basis. Is anybody can help me to automate the column copy paste and correct record
maintain in excel with large number of rows increasing daily using Power Query. As I m new to it. And don't know where to start from.

 

[Anbuselvam]

@kabirr Please post the sample file with expected results. So that you will get answers ASAP.