How to search data

[biswajit paik]

I have a table of data, with the heading like Author ,Name of Books,
Publisher, Subject. Now I want to search data. Subject wise . Like If I give
History then I want all books under history subject.. & I want to do this
under a drop down box.

Ho to do this

 

[paul.robinson]

Hi
Just checking, but autofilter does this. Will that do, or do you know
about autofilter and want the drop down box?
regards
Paul