The lists are not next to each other. The one that gets updated has many repeated names. The other lists is a summary of them all. So i can't line up the lists and compare them. I'd need to highlight both ranges and do some sort of comparison to see what names appear in one list but not the other. Any suggestions?
Then use autofilter and filter for N/A. Select all of the cells you get from the filtered list, and hold down the Alt+; keys. This will let you select visible cells only. Copy and paste to another location if that's what you want.