View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matto Matto is offline
external usenet poster
 
Posts: 5
Default macro to scan list

If anyone can help that would be great,

I need a macro to scan a list of text in column A of sheet1, several text
names are repeated multiple times in this column. I then want the macro to
return only one cell of each text name that occurs in the list to column B
on sheet2.

I know this should be easy, but Im still learing. Thanks!