View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
np np is offline
external usenet poster
 
Posts: 10
Default 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