Multiple Terms - Single website - Auto search

[Blessy Clara]

Hi all,

Could some one please help - if there a way to automatically search for multiple names/ in a given webiste

Step 1 - Automatically go to the website
Step 2 - Check if the names are available
Step 3 - If name found - give as Yes (in Column C)
If name not found - give as No (Column C)

For example
http://npg.dl.ac.uk/NPG/People/

I have a list of names (100+) of which three names are found in this website
Example

John Simpson
Roy Lemmon
Victor Pucknell

When the names list goes beyond 100, manual "Find" becomes too cumbersome. So is there a vba code to automatically search for all the names in a given website,

So it would be like
Column A - has the names
Column B - the websites
Coulum C - If names found yes.if not found then No

After Macro
View
Column A
John Simpson
GAPONENKO
DEMIR
HEIDERNAETSCH
Roy Lemmon
von BORCZYSKOWSKI
TORRENS
KUZHIR
MAL YUKIN
GRYNYOV
Victor Pucknell

Those highlighted in red are names found in the website (this is for easy understanding - macro not required for colors)

Thank you