Hello,

I have a simple task that I am not quite sure how to implement.

Put simply, I have to look at 2 lists of names. One gets generated automatically and I am not notified of any updates. The other list keeps a running total of some other metric I have already created a macro for. What I need is another macro that will scan the "automatically generated" list and will add any new names to my existing list.

Example:

My list:

Bob 5
Frank 4
Joe 0
Mary 0

Automatically generated list:

Bob
Sally
Frank

I need Sally's name to appear in "My List".

Any suggestions?

Thanks!

Shannon