I have a worksheet with many lines of data and I want to be able to find a way to type a string in and be presented with a list of all lines in the worksheet that contain the string, no matter what column they are in. So for example -
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]boy[/TD]
[TD]dog[/TD]
[TD]hat[/TD]
[TD]blue bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ball[/TD]
[TD]horse[/TD]
[TD]birdman[/TD]
[TD]car[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]lorry[/TD]
[TD]keys[/TD]
[TD]hand[/TD]
[TD]cup[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]bird[/TD]
[TD]dog[/TD]
[TD]boy[/TD]
[TD]ball[/TD]
[/TR]
</tbody>[/TABLE]
I would like to type the word "bird" and be presented with the following list -
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]boy[/TD]
[TD]dog[/TD]
[TD]hat[/TD]
[TD]blue bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ball[/TD]
[TD]horse[/TD]
[TD]birdman[/TD]
[TD]car[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]bird[/TD]
[TD]dog[/TD]
[TD]boy[/TD]
[TD]ball[/TD]
[/TR]
</tbody>[/TABLE]
I am not sure where to start. Is this best tackled with VBA? is there something I could do with pivot tables? I want to make it as simple as possible to enter the search term so user does not have to enter wildcards to get the full results.
Any clues would be gratefully received
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]boy[/TD]
[TD]dog[/TD]
[TD]hat[/TD]
[TD]blue bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ball[/TD]
[TD]horse[/TD]
[TD]birdman[/TD]
[TD]car[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]lorry[/TD]
[TD]keys[/TD]
[TD]hand[/TD]
[TD]cup[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]bird[/TD]
[TD]dog[/TD]
[TD]boy[/TD]
[TD]ball[/TD]
[/TR]
</tbody>[/TABLE]
I would like to type the word "bird" and be presented with the following list -
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]boy[/TD]
[TD]dog[/TD]
[TD]hat[/TD]
[TD]blue bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ball[/TD]
[TD]horse[/TD]
[TD]birdman[/TD]
[TD]car[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]bird[/TD]
[TD]dog[/TD]
[TD]boy[/TD]
[TD]ball[/TD]
[/TR]
</tbody>[/TABLE]
I am not sure where to start. Is this best tackled with VBA? is there something I could do with pivot tables? I want to make it as simple as possible to enter the search term so user does not have to enter wildcards to get the full results.
Any clues would be gratefully received