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
|