looking for VBA code to return a value in a single cell of the sum of cells with matching criteria.

Attached is a workbook that I get pulled from our POS system. I have deleted 1300 rows to cut on clutter and to use as sample data.

I have 2 tabs, "What I get" and "What I need". next to each part number is a quantity for a specific order. Some parts are listed several times but I need only one value for that Part Number. I want to go through the list of orders and find out how many total parts are ordered and return a value in the last column "Notes" next to the first record listed and empty cells for the rest of the rows with the same Part Number.

I have a function that I have put together to get the report to look like the "What I get" tab and would like to add this last piece of code to finish the project.

Thanks in advance

Sample.xlsm