View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeCM MikeCM is offline
external usenet poster
 
Posts: 25
Default Compare 2 lists and show reconciliing items

Is there any easy macro to look at a range of values (numbers) in a
column on one worksheet, look up a range of values in a column in
another worksheet, and (a) paste into another worksheet the values that
appear in the first but not the latter, and (b) that pastes in another
worksheet the values that are common to both? Thanks for any
suggestions.