I'm fairly new to excel and need some help. I need to merge the entire row from SS1 and SS2 into SS3. Simple enough but if an item in SS2 column A matches an item in SS1 column A and the date in SS2, column D is newer than SS1 column D, then copy then merge the row from SS2 into SS3 and on thru the list. There are several thousand items in SS1 and a few hundred in SS2 and all items need to end up in SS3 (latest dates) without duplicates. I've tried match and vlookup but can't seem to get the date part, I think I get it right but then find duplicates or the wrong date. Here's what I'm working on, please help if you can spare the time. I'm probably copying and pasting these wrong but here goes. Many Thanks in Advance!