Merge SS1 & SS2 into SS3 by latest date

SocLost

New Member
Joined
Oct 8, 2014
Messages
1
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!

SS1
Lot
QtyStatusExpires
AIV260827full10/24/2014
AIV261872full1/31/2014
AIV26235845%10/25/2014
AIV263818full9/10/2014
AIV264883full1/31/2014
AIV265908full9/15/2014
AIV266818full10/18/2014
AIV267834full10/23/2014
AIV268798fullexpired
AIV269253%10/25/2014
AIV270807fullexpired
AIV27178198%10/10/2014
AIV2721077fullexpired
AIV2731337fullexpired
AIV2742075full
AIV2752433fullexpired
AIV2762305fulltbd
AIV2771368fullexpired
AIV278869fullexpired

<tbody>
</tbody>
SS2
LotQtyStatusExpires
AIV261L4832full5/9/2015
AIV264L4838full5/16/2015
AIV268L4840full11/10/2014
AIV285L4831full11/23/2014
AIV306L3800full7/8/2015
COL011L4836full5/27/2015
COL013L4921full11/10/2014
COL014L41135full11/9/2014
ERP016L4906full1/3/2015
ERP025L4828full5/30/2015
ERP026L4913full5/4/2015
ERP027L41059full5/5/2015
ERP028L4851full12/26/2014
ERP029L4887full11/19/2014
IMG001L4802full1/1/2015
LS1010L4839full5/6/2015
LS1011L4831full5/11/2015
LS1013L4330.10%10/8/2015
LS1015L4978full5/9/2015

<tbody>
</tbody>
Final Results in SS3
LotQtyStatusExpires
AIV260827full10/24/2014
AIV261832full5/9/2015
AIV26235845%10/25/2014
AIV263818full9/10/2014
AIV264838full5/16/2015
AIV265908full9/15/2014
AIV266818full10/18/2014
AIV267834full10/23/2014
AIV268840full11/10/2014
AIV269253%10/25/2014
AIV270807fullexpired
AIV27178198%10/10/2014
AIV2721077fullexpired
AIV2731337fullexpired
AIV2742075full
AIV2752433fullexpired
AIV2762305fulltbd
AIV2771368fullexpired
AIV278869fullexpired
AIV285831full11/23/2014
AIV306800full7/8/2015
COL011836full5/27/2015
COL013921full11/10/2014
COL0141135full11/9/2014
ERP016906full1/3/2015
ERP025828full5/30/2015
ERP026913full5/4/2015
ERP0271059full5/5/2015
ERP028851full12/26/2014
ERP029887full11/19/2014
IMG001802full1/1/2015
LS1010839full5/6/2015
LS1011831full5/11/2015
LS1013330.10%10/8/2015
LS1015978full5/9/2015

<tbody>
</tbody>
Many Thanks for any assistance.

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,896
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top