Help how to Update spreadsheet

SemperFi4000

New Member
Joined
Nov 20, 2020
Messages
1
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,306
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,129,804
Messages
5,638,450
Members
417,025
Latest member
MusterDuster

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top