Button for excel that searches all sheets then outputs to seperate sheet

Hey guys,

As the title states, I'm creating a fault log for my work. Each application that we support has a seperate sheet. I'd like to create a button that allows us to search each sheet then output its findings to a new sheet. If possible, I'd like this sheet to be wiped every time a new search is performed as otherwise I imagine it would get quite cluttered.

Hopefully that's enough information for you guys and thankyou for all your help!

Originally Posted by Shooper101

Hopefully that's enough information for you guys and thankyou for all your help!

Actually Shooper101, there is no information at all.

It would really help if you attached a sample workbook so that we can see what you are looking to extract from the various sheets, and where you want it written on the master sheet.

Regards,

David

I'll do that tonight

Originally Posted by David A Coop

Actually Shooper101, there is no information at all.

It would really help if you attached a sample workbook so that we can see what you are looking to extract from the various sheets, and where you want it written on the master sheet.

Regards,

David

I've attached a sample spreadsheet, hopefully it's clear enough.

Do you need me to clarify anything?

Sorry - it's too hard for me. I am still in the dark about what you want.

Thanks for at least trying, I'll do my best to clarify.

Basically, I'm looking for a button that takes user input, searches all the sheets for that term, then outputs the results of that search into a new sheet. The complicated part is wiping that sheet every time a new search is performed.

OK Shooper - Got it! (It was a bit late last night)

I have made a few changes to your workbook.

In Col A, I have listed the sheets you wish to search. This has two purposes.
1. The list provides the SEARCH macro with the names of the sheets to look at (for Printer for example.
2. There is now a drop down box which takes you to that sheet. You don't have to use the hyperlinks attached to text boxes.

To use this, just type the keyword (which will be in Column A of each of the App sheets), and click the button. The app will firstly clear everything on the Search Results sheet, and then list everything is finds. (I added a ref to the sheet in col D)

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.