Delete Row When Cell Value is a Duplicate

[ajocius]

I'm running Windows XP using Excel 2010.

What I have now: Hope there is a sharp moderator who can assist me in this long journey. I have two spreadsheets which are merged, one below the other. Spreadsheet A is a database and spreadsheet B is an update with weekly data. The contents of B are added to the bottom of A. In column D there are supposed to be unique values. Sometimes the update spreadsheet contains remnants from previous updates.

What I would like help with: Using VBA, I would like to compare the values in column D (starting from bottom to top). If I get a match, need to delete the row closer to the bottom versus the one in the database. This ensure integrity of my database spreadsheet.

I call the last row in the database lastRowInDatabase and I call the last row of the combined spreadsheet lastRowInCombined. The contents in column D are numbers.

Crossing my fingers one of you sharp guys/gals can give me a hand.

Tony