SemperFi4000
New Member
- Joined
- Nov 20, 2020
- Messages
- 1
- Office Version
- 2019
- 2016
- Platform
- 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,
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
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,
- If the sku has a Match in the main spreesheet, update row. (only sku, fruit, quantity)
- if the sku in CSV doesn't exist in Main spreedsheet, then add new row. (sku, fruit, quantity)
- In the current situation, Location and BU would be added manually
- if the sku in the Main spreedsheet doesn't exist in CSV, then delete row in Main spreedsheet.
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