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
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