Help how to Update spreadsheet

[SemperFi4000]

Hello, I am trying to figure out, what is the best way to update my main spreedsheet, and if possible an example of how that can be done.
Below, I have a Main Spreadsheet, and it needs to be updated daily.
The Below, CSV file, has new data. and the sku is the unique key,

1. If the sku has a Match in the main spreesheet, update row. (only sku, fruit, quantity)
2. if the sku in CSV doesn't exist in Main spreedsheet, then add new row. (sku, fruit, quantity)
   1. In the current situation, Location and BU would be added manually
3. if the sku in the Main spreedsheet doesn't exist in CSV, then delete row in Main spreedsheet.

Thank you for your Help.


Main SpreadSheet:
Sku Fruit Quantity Location BU
12345 Apples 25 Lab1 BU-17
23456 Oranges 30 Lab2 BU-15
34567 Peaches 15 Lab3 BU-17
45678 Lemons 10 Lab4 BU-17
56789 Pears 15 Lab5 BU-15


New Data: CSV data
Sku Fruit Quantity
12345 Apples 23
23456 Oranges 24
56789 Pears 9
78901 Limes 20
89012 Grapes 30

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your "Main" sheet and "New Data" sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).