Searching for records

DuckBill · Feb 13th 2003

I have a multi-worksheet Excel 2000 file that is being used as a type of database (I say "type" because it is not formatted very well for historical reasons!) and the users would like to be able to search across all the sheets for any records that include a particular text string (e.g. "bearing") and then create a copy of each of those records on a separate worksheet for comparison purposes.

I am fairly confident(!?) that I can create some code that will do this, but I just wondered if there was a standard feature that I could utilise instead?

Any ideas?

DuckBill

**royUK** · Feb 13th 2003

It really depends how your Workbook is set up. Take a look at ythis example., it searches a particular column in a worksheet for a text string and returns any finds to a results page

**royUK** · Feb 13th 2003

Here's some tips to create a database that I wrote for my colleagus at work

DuckBill · Feb 13th 2003

Roy,

Many thanks for the response; the code looks very useful. I guess it also means that there are no "easier" ways of doing this using standard features, as I suspected.

DuckBill

Searching for records

Participate now!

Share

Users Viewing This Thread