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.

My best guess, provide a sample worksheet with a clear before and after picture. Sounds pretty straightforward, but a sample would be helpful.

here is the sample file

Attached Files

SampleFile.xlsx (10.1 KB, 8 views)

Cross post

Cross posted without links http://www.excelforum.com/excel-gene...matically.html

Please add links to all your cross posts before continuing. Read http://www.excelguru.ca/content.php?184 to understand why.

Thank you

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post