Search and return all results across all worksheets problem.

I'm sure this is said a lot on here but here goes, I'm still fairly new to excell, now that is out of the way...

I have been working on a spreadsheet to list prices of products that my company regular purchases, this info is used to price refurbishment work. The spreadsheet now contains too much data to easily find what someone is looking for, so I am trying to implement a search page with a simple search button to prompt the user to input text for what they are searching for and to return all results found in a table underneath, then to clear results afterwords. I have attached an example wokbook with a few short explanations inside it. Help with the code would be most appreciated.

Luke.

Example1.xlsx

Hello, and welcome to the forum.

Is something like this what you're looking for?

Please Login or Register  to view this content.

Thank you, this works exactly how i wanted it to with one exception, it does not clear all cells after a new search has been started, it leaves data in cells a2:e10.

Any thoughts?

It shouldn't be writing anything to cells A2:E10, they were blank on your original example, so I wrote the data in cells A11 onwards.

Perhaps you could upload an updated book showing the problem

Not a problem.

Change the line of code:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Many thanks for your help most appreciated.

Once the search has been performed and then cleared, the comment then stays attached to the cell.

If you search "ply 18mm" for example then press the search button and canel it the comment then stays. Any way of clearing this once the search has been performed?

OK, remove the line near the start that says:

Please Login or Register  to view this content.

And replace it with:

Please Login or Register  to view this content.