Matching Data between Files , Deleting Matching Rows

This forum has been absolutely amazing in helping me prep some data I have for a major DB import! Hopefully, you wonderful gurus can help me one last time.

I need a macro that will let me compare values from workbook to values in another, and then delete the rows that match.

Attached you will find two spreadsheets (Legacy Data Sample is only a small sample of a 15k record spreadsheet).

I need to check column A of worksheet 1 in SSMC DELETE against column K in worksheet 1 of Legacy Data Sample. For matching values, I need to delete the entire row in the Legacy Data Worksheet.

Then, I need to check column A of worksheet 2 in SSMC DELETE against column H in worksheet 1 of Legacy Data Sample. For matching values, again, I need to delete the entire row in the Legacy Data Worksheet.

If anyone can help, it will be much appreciated! Thanks in advance!

can you not do it in the db using sql?

Hi Nathan,
Unfortunately, I am but a lowly tech support guy. I don't have sql access to the database and the admins who do are the ones that tasked me with this as they are "too busy" to prioritize it. I only have access to a front-end user interface that can't run any kind of queries, so any data matching with conditional actions like this have to be done in excel.

Please Login or Register  to view this content.

I haven't double checked this

Hi Nathan,
Thanks for the code!

I just tried it, but no effect.

Here is what I did.
1) Opened ssmc delete.xlsm,
2) alt+F11 to open visual basic,
3) copied the code in, changed the file paths for the locations of the two spreadsheets
4) saved as macro
5) pressed F5 to run

VB returned a message to confirm that I wanted to re-open the file. I clicked okay, and the file was re-opened along with Legacy Data sample -- but no other changes were made.

I'm a total novice at VB Macros, so any more help you can give would be appreciated. Thanks!

sorry, do it from a new workbook.