Hello!

First time poster, I'm willing to read up on things but I was hoping someone could direct me to the appropriate location (or tell me what to do, hah)

I have no experience with VBA but I was told I need to use it to do what I need to do:

I have a list of 600 names that I need to omit from a database of 100,000. The names of 100,000 are in a column that is attached to a database of 20 columns. I need to delete these names from the list of 100,000 and the entire row that the name corresponds to.

So far I can find the names doing the LOOKUP function. And I have them matched with my list. However, I do not know how to make excel tell me in which row the LOOKUP function found the names, nor do I know how to tell excel to delete the row in which it finds the name.

While it would be nice if you could do my job for me and just tell me what VBA code I need, I realize that that's a bit of a stretch. If someone could direct me to where I could learn how to do this I would appreciate it. Google searching this does not provide any explanation of basic foundation for me to develop my own code, and I don't really want to begin from scratch (if possible).

Cheers,
Vital