Hello, I have two sets of data. in sheet1 I have a list of people. In sheet 2 I have a list of people that need to be deleted from sheet1. I want to create a macro so that if any cell in column A sheet1 is equal to any of the data that is in column A sheet 2 to delete the entire row in sheet1. This is just a small sample as I have 1000's of lines (people). Any help would be greatly appreciated! Thanks!
Marc
Sheet1
Column A
Marc
Beth
Michelle
Sarah
Shelly
Lynda
Marc
Casey
Sarah
Robert
Seth
Shelly
Debbie
Robert
Marc
Sarah
Sheet2
Column A
Marc
Shelly
Robert
Bookmarks