View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrwawa mrwawa is offline
external usenet poster
 
Posts: 7
Default How to filter list from pre-existing list

Hi all,

I have a list of names with codes and a smaller subset of just codes.
How can I filter the larger list of names w/ codes from the subset
list, in order to transfer the names from the larger list to the
subset? I have tried the advanced filter option, but it wants to look
at individual cells. Do I need a macro that will cycle through the
subset and compare it to the master list?

Thanks,
Wade