HI Gurus,
I have workbook contains 3sheets 1. Data sheet 2 List sheet 3. CopyFromDataNotMatch.
I need Data sheet column A looks to list sheet Column A if names are not matched , the unmatched rows copy to CopyFromDataNotMatch sheet and after that Delete the rows from Data sheet which are not matched with columnA Names of list sheet.
The sample is attached.