delete value on worksheet 2 that match values on worksheet 1
 

Is there a way to delete rows in worksheet 2 that match the values in
worksheet 1 through some excel feature or programatically? For example my
worksheet 1 has about 10000 row of data. I need to file the matching rows in
worksheet 2 and elimiate those rows in worksheet 2.

thanks
nick