Search mssing values in data dump

[Crispy85]

Hi all,

If i have one sheet (BASE SHEET) with in column a some names.
For example"

Names:
Dave
John
Alex
Tim

I have another file with a dump of the data. In this file in Column A there is also the corrosponding names. But in this one there are also lines with the name Bart.
I would like a script that checks if all names in the Data Dump, exist in the BASE SHEET, if not then msgbox ("Bart not found in Names").

Can someone help me with a script?

Thanks!

[Mumps1]

What are the full names of both files including the extension? What is the name of the sheet that contains the names to search in each file?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Crispy85]

Hi John!!
Thanks for the answer and i think it does what it needs to do.
I have only one more request.

If a name for example has 10 items in the DATA DUMP, i get the message "xxxx Not Found in Names" 10x.

Could this be cut back to 1x?

Thanks!!

[JOHN H. DAVIS]

Can you attach a sample file to test on?

[Crispy85]

Hi John,

Sure.

thanks!

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[Crispy85]

Hi John

Thanks, this is awesome!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and reps.