Link two columns then exclude rows in one column

[richard12]

I have 2 sheets in the same workbook where I need to exclude/delete rows in one sheet when the values are not found in the second sheet. The two sheets are imported from downloaded workbooks. The result is a workbook that has two sheets where Sheet1 may have rows that need to be deleted.

Example:

Sheet1 (where rows may be deleted) has unique values, such as organization codes, in column A: 91, 92, 93, 94, 95, 96, 97, 98
Sheet2 (where values are the same as Sheet1) has multiple values, such as employees, in Column F: 91, 91, 93, 93, 94, 91, 95, 94, 91, 93, 97, 98

The Sheet1 rows to be deleted, organization codes of employees who left, would be 92, and 96.

I'm not sure how to connect these two columns and/or how to proceed to delete, or mark rows for later deletion, in Sheet1.

I'd to do this in VBA as part of a Macro process.

 

[richard12]

I've found I can use Match and VLookup for most of the rows. Now my problem is some values do not match when they should. The values are the result of a macro copy/paste where I get the first 8 characters of a cell using (left(a1,8) which appears to work, I can see the result and it looks correct. However when I match or lookup the other table, some formulas work and some do not. Yet when I keyboard over the same values that do not match up, the typed values are always found and result in the correct reply.