Do you have a large amount of data held in an Excel Spreadsheet ?

• If so, you will be well aware how difficult it is to find things

This tip demonstrates a way using VBA that enables you to search through your data really quickly, and helps you to find what you are looking for.

What I have written is a demo I used for searching through flight details.

- You type the airport in the box, and the code loops through the records, and returns the relevant airports.

Here's a screen shot of our data in Excel:

As you type, the code looks in the DB for the string, and displays the results where the string "Lon" is found:

Download sheet to practise how to Fast Search in Excel

- Open the sheet, and type "LONDON" in the box for a demo

If you would like ExcelExperts.com to implement this for your Excel based system, please contact us to Request a quote

Nick

Training Video on Fast Search: