Search and find info, if correct info found copy into new worksheet

Hi,

I have approx 15 worksheets for my workbook containing lots of information of importance.

I want to be able to look for a key work on any of the worksheets and then have this automatically pasted into a new worksheet on demand.

I have seen Search Macro's working so i suppose i need something similar to this that will bring forward a box asking for what you want to search for..

Any suggestions on what VB macro to use??

Maybe this:

http://www.excelforum.com/excel-prog...ste-macro.html

Try taking all the code out of the Module. Then manually type in Sub SearchSheets and press Enter. If the macro name is accepted, you will see this:

Please Login or Register  to view this content.

...excel adding the underlined stuff.

Now paste in all the code that goes between.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.