Find duplicates rows, sum cells then remove duplcate rows

Hi All,

I am looking for a macro that will check the the values in 2 columns and if a match is found sum up the qty in another column and put this value in the row what will be kept before removing the duplicated rows.

The attached file shows the data and the result expected, my current file is 40k rows and will grow.

If col B & col C are the same
Add up the values of col N, based on different dates in Col O
Put the SUM of col N duplicate rows into the row with the newest (latest) date in col O
Remove duplicate rows
The qty Ordered col G should total the Made qty col N and the Shipped qty col E

Any help would be appreciated

If you need clarification on anything please let me know.
Thank you