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??
Last edited by JnrParki; 08-13-2011 at 02:55 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi,
Thanks for quick response. Have just tested this now and it's bringing forward an error on the opening line.
Sub SearchSheets()
It just keeps highlighting this yellow saying:
Compile error: Expected: Identifier.
Any further suggestions???
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:
...excel adding the underlined stuff.Sub SearchSheets() End Sub
Now paste in all the code that goes between.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Re: Search and find info, if correct info found copy into new worksheet
This works brilliant now
Thanks
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks