I have a main worksheet with a list of everyhing, and then 12 more worksheets
with smaller lists. What I am doing is typing in something on one of the 12
worksheets and using vlookup to find that on the main worksheet and transfer
the numbers that correspond. Here is an example:

Main Worksheet
Bob 1 4 3 9 2 7
Shawn 2 3 4 7 5 8

Other Worksheets
I type in "Bob" and the corresponding numbers come up next to Bob's name.


What I would like to do is have the program automatically highlight the name
on the main worksheet whenever it is typed in on one of the other worksheets
to make it easier to see who has already been used.

I'm thinking I need to go to the main worksheet and put some type of "IF"
statement in with the names. I would probably use vlookup for that too, and
just have it search each of the 12 pages, if it finds it, highlight the name,
and if it doesn't find it, do nothing.

Any help is greatly apprecaited, let me know if there is anymore information
you may need.

Thanks in advance!