|Subject:||Extracting rows from a file based on another|
|Posted by:||Thorbjorn Sundboe (plea…@replytonewsgroup.com)|
|Date:||Fri, 21 May 2004|
I have 2 excel files where on is a subset of the other. All rows are
uniquely identified by a number. I would like to automatically extract the
rows in the subset from the superset, resulting in a 3rd file with the
difference between the two, like a batch operation. Do I need a utility for
this or is there an option in Excel that allows me to do this?