Hi All,
I have a task given to me to create a search method. I have to search all sheets except for the Instruction sheet, for text entered into a search for cell on the Instructions sheet and return a list of row that have that text in them.

rough idea on how it should work
1 enter text to search for into "D4" (text to search for)
2 click a command button to start the search
3 look in all sheets except the Instruction sheet
4 return the data in the row that matches the search
5 display this in "D6:Q6" along with a reference to the location (sheet and row # in "C6")
6 only provide a maximum of 10 results.

I could try and patch this together from various bits of code I might find, but I know it would have lots of problems if I did it that way. Could somebody provide the code for this or a starting point to create my own code.



regards
Trevor