Hi

I would like to extract from a massive list of names, all occurrences of one name and display the data on a new sheet.

for example;

Name Date Location
James 23/04 edinburgh
Jimmy 28/04 london
David 03/05 Belfast
Sarah 08/07 Glasgow
David 12/09 Birmingham
James 13/01 Manchester

So the output on the new sheet would be;

Name Date Location
James 23/04 edinburgh
James 13/01 Machester


I basically want to find where James has been and on which dates without having to scroll through 1000's of names.

Thank you for any help