PDA

View Full Version : Searching through a list



andreeew
11-19-2011, 05:07 AM
Hi,

I am pretty new to all this so please forgive my ignorance (:
I have created an excel sheet which holds all the movie's I own and a macro which allows me to add a new movie, find a movie, delete a movie, etc.

The problem is when I search for a movie using my 'FIND' button and entering my search, the worksheet scrolls through the movie's and finds the movie's which meet my criteria alphabetically (first word). Instead I would like for the macro to open a new box or even sheet which contains all the movie's which contain the word/phrase I have entered in my search field.

So I was wondering if anyone has any ideas about how I should change my code or how I should go about doing it. More information can be provided as needed. (:

thanks,

mdmackillop
11-19-2011, 08:15 AM
Sounds like you just need to use Advanced Filter. Check the Excel Help.