I have an Excel Sheet1 with columns: FirstName, LastName, LastDatePurchased
I need to update this list with the data from another Excel Sheet2 with columns: FirstName, LastName, ProductType, LastDatePurchased
This excel file is big file and source of the data, here is what I need to do.
1. Find all the rows in Sheet2 where ProductType=”Food” (other records I am not interested in)
2. Look at FirstName, LastName in Sheet2 and match with the ones in Sheet1 update LastDatePurchased in Sheet1 with the value from Sheet2
3. If there is extra rows in Sheet2, meaning not available in Sheet1 where ProductType=”Food”, I would like to add these records bottom of the Sheet1.