Need to delete rows from supplier stock list to only show stock I sell

Please Help!! 🙏

Its been a while since i've worked with excel hence asking what is probably a simple question.

But I have a sheet containing around 70 stock order numbers (like part number) for the products I sell from a supplier. Each day, I receive a report (.csv) from my supplier that has ALL (around 2000) of their available stock details and changes.

As I am only needing to update details for the products I am selling, I need to either delete rows from my suppliers list that don't match my stock order numbers OR alternatively, export a new .csv file with updated details of my products only with details from suppliers report.

So in summary if my stock order number (on one sheet) matches my suppliers stock order number (on a different sheet), I need the all details (approx. 19 columns) from suppliers report and if it doesn't, I don't need to know about it. (delete from suppliers csv??)

Hoping to get a speedy resolve as this issue is vital to integrate a new function in my online business product feed.

Many thanks in advance🙏

Thanks heaps Marvin
Am having a play now and its not quite working??? Probably me but i have attached two .csv files in this thread. Is any chance you could please run through it with the actual data I will be using please. Also, I take it that for the advanced filter to work, the files need to be .xlxs as opposed to .csv?? I need my final output to be a .csv so it can feed into the back end of another platform. Any ideas

Thanks Heaps Marvin

You have pointed me in the right direction which I am very much appreciative of. I will try not to to tare too much of my hair out as I play around and figure it out!

Sleep well and thanks again. I will update thread with how I go! Many thanks

YOU ARE AMAZING!!! If i go wrong from there, there is definitely something not right with me!

Thank you for including the pic as well!! Great stuff! Will guard that file with my life!

Now its sleep time for you - thank you so much mate! you've been a huge help! God bless and stay safe amidst all this Covid-19 business!