View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
computers hate me[_2_] computers hate me[_2_] is offline
external usenet poster
 
Posts: 1
Default macro comparing two different lists

I have two sheets i havea column of set names in sheet 1 column A and Sheet
2 has another list of names in column B.
I need a macro that compares both lists. If one of the names in Sheet2
Column B is not found in sheet 1 column A place that name in sheet 1 column B.