View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sylink sylink is offline
external usenet poster
 
Posts: 30
Default Searching and Matching Lists

Pls help with a macro to solve the task below:

Sheet1, column A has an unfixed or undetermined range of names
starting at "A2".
Sheet2 column A has a related name list also.
For every item in sheet2 column A, search through sheet1 Column A
Where a match is found, indicate "PRESENT" in the corresponding cell
in Sheet2 column B.