Searching a column within excel and listing multiple results

[Eleanor19]

I'm honestly not sure if this is the right area for this...

I've got a list of about 3000 books (all listed in one column) and I'm trying to create something that will search through them with a word and list all the results (i.e. search with the word briggs would return a list with all the results containing the word briggs), I've tried recording a Macro with Ctrl + F but it's not working.

I've attached a file with a bit of the list to give you an idea of what I'm working with, any suggestions would be great ^^

[VBA Noob]

You could look at custom filter or with a event macro (See attached. Change A2 to run)

Link explains more about Advance filter

http://www.contextures.com/xladvfilter01.html

VBA Noob