Hi, I am hoping to make a database of articles from car magazines in order to find any relevant information quickly, each row would consist of the following sample info;
MAKE MODEL ARTICLE ISSUE PAGE No
FORD ESCORT ENGINE JUNE 07 25
ETC, ETC.
Eventually this list will consist of several hundred rows. The problem I have is that when searching for an item, eg " ESCORT " excel will highlight all mention of " ESCORT" but will still show the complete database, and I have to scroll down the whole list.
Is there a way for excel to show only the relevant rows that contain the search word.
Thanks, John
Bookmarks