Delete Rows with value not found on Sheet2

[morkar]

Hello,

I have an excel workbook with a sheet "ExportedData" in column D, there is a value, if that value does not exist in another sheet, Sheet2, in my workbook I would like to delete the row. Sheet2 has numeric values in column A, A1-A85. This range can increase over time. The ExportedData sheet has over 200K rows, in columns A-L. If the value in Column D does not exist in Sheet2, column A, I would like the row to be deleted.

Thanks!
K

 

[Fluff]

You're welcome & thanks for the feedback.