Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project.
For Example This week I might need 4 - BT01 (Entry Name) then as the project goes on the next phase I'll need 5 more - BTO1.
I'm trying to make a Master sheet Look at the order sheet every time it finds a BT01 it will take the qty ordered and add it total For that one item and display it on this new Maser list sheet I'm trying to make.
I plan to do this for the item for QTY Rec'd, QTY Ordered, Outstanding, How many shipped to the job.
Any suggestions how to make this come to life?