I checked the contents of each cell in Col A in the source sheet against each cell in Col in the dest sheet. If it exists, I paste the contents of the appropriate cells across columns A:G, if not, then I added the row to the next available row in Dest sheet.