I have two workbooks. I want to use the 'Find' tool on workbook A and search for a single word or string, upon clicking 'Find All' it displays the results below. I want to make a macro that will see the results and copy the ENTIRE row of where the result was, and paste it in tab 'my results' on worksheet B in the next empty row.
any suggestions? was I clear enough?
If the text string is being searched for in the same column, then the AUTOFILTER was designed for this.
1) Turn on the Autofilter (DATA > FILTER > AUTOFILTER)
2) Click on the column drop down
3) Select Custom
4) Use Contains: myvalue
Now you're looking at all the rows with that value in that column. Copy the whole thing to another sheet.
Those steps can be made into a macro, but that may be overkill.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks