Hi,
I have an excel sheet with 7 sheets, called, for example 'Index", '1. tim', '2.kim' etc..
In the index sheet I want to create a search button, which when I enter a term, say 'jimmy', into cell D13 I can then hit the Search button and in the rows beneath will return the results from the other 6 sheets i.e. '1. tim' and so forth. Ideally, would like the results to show the whole row in which 'jimmy' appears.
Been trying to work the correct macro, but to no avail.
Any help would be much appreciated.
Thanks.
I have an excel sheet with 7 sheets, called, for example 'Index", '1. tim', '2.kim' etc..
In the index sheet I want to create a search button, which when I enter a term, say 'jimmy', into cell D13 I can then hit the Search button and in the rows beneath will return the results from the other 6 sheets i.e. '1. tim' and so forth. Ideally, would like the results to show the whole row in which 'jimmy' appears.
Been trying to work the correct macro, but to no avail.
Any help would be much appreciated.
Thanks.