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?