Search box for two columns A & B

[Billy69]

Hi All,

hope you can help, i have put a list of drivers & there routes (train drivers) names in A routes in B

i can use the filter tab to search for specifics by typing a part of a route and it shows all the drivers who go over that route.

what im trying to do is make it a bit easier to use by having a search box & a display box with the details it finds. while hiding or covering over the names & routes as there are about 3500 lines.

many thanks.

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a new post

To add a file to an existing post.

[Billy69]

hope this helps :-)

[davesexcel]

http://www.xlorate.com/excel-questio...s%20you%20Type

https://youtu.be/E6Nj2vIvlpI