View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
np np is offline
external usenet poster
 
Posts: 10
Default Delete values in sheet 2 that arre found in sheet 1

Is there an easy way to delete values in sheet 2 that match the value from
sheet 1. I have approximately 10000 rows in sheet 1 and some identical rows
on sheet 2 that need to be eliminated? I not sure if this has to be done
pragmatically or if there is some feature in excel 2007 that can handle this
type of request.

thanks
Nick