<div>
In the file you say<br />
&quot;...the &quot;scan&quot; (in column B) should extract content of both column A and column B into another worksheet (or external XLS file).&quot; <br />
<br />
Do you sometimes want one or the other or can it be only a worksheet in the current workbook?
</div>


<div>
Martin:<br />
<br />
Thank you for the lightning-fast response... I appreciate it.<br />
<br />
Ultimately, whatever is easier for extraction purposes. &nbsp; If either method is equally straight-forward, then I would prefer to add the content to another tab (within same spreadsheet).<br />
<br />
EEH
</div>


Macro--Searching-for-Message-Prefix.xlsm

<div>
Rgonzo1971, Martin Liss:<br />
<br />
Both solutions work great... thus, I wanted to award points to both of you. &nbsp; I hope that's ok.<br />
<br />
Given that Rgonzo provided his solution first, I awarded the majority of points to him.<br />
<br />
Again, both solutions exactly follow the envisioned process. &nbsp; Thank you for coming up with such an excellent solution!!! &nbsp; <br />
<br />
As always, I appreciate your assistance.<br />
<br />
Cheers,<br />
EEH
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
<br />
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
</div>


<div>
Rgonzo1971, Martin Liss:<br />
<br />
Again, thank you for your most excellent help yesterday. &nbsp; Based on the same process, I now have a need for another process. &nbsp; I think this one, however, may be a bit more challenging (at least from my perspective).<br />
<br />
Below is the URL (new question):<br />
<a href="https://www.experts-exchange.com/questions/28911018/Macro-module-searching-for-message-content.html" rel="ugc">https://www.experts-exchange.com/questions/28911018/Macro-module-searching-for-message-content.html</a><br />
<br />
It would be awesome if you please have a look at this requirements/need. &nbsp;<br />
<br />
Thank you in advance,<br />
EEH
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts:<br />
<br />
I kindly request your assistance in developing a macro (in VBA) that allows me to search through a spreadsheet that contains several tens of thousands of records.<br />
<br />
As a picture is worth a thousands words, I have attached an example XLS with additional information.<br />
<br />
I tried to keep the information and background generic and short. &nbsp; Hopefully, the info in the XLS provides sufficient detail. &nbsp; If not, please don't hesitate to ask for additional info.<br />
<br />
Thank you in advance!!<br />
EEH<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/01_w02/1066123/Macro--Searching-for-Message-Prefix.xlsx" target="_blank" class="file-inline" title="Macro--Searching-for-Message-Prefix.xlsx (11 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Macro--Searching-for-Message-Prefix.xlsx</a>
</div>
</div>


Macro--Searching-for-Message-Prefix.xlsx

Hello Experts:

I kindly request your assistance in developing a macro (in VBA) that allows me to search through a spreadsheet that contains several tens of thousands of records.

As a picture is worth a thousands words, I have attached an example XLS with additional information.

I tried to keep the information and background generic and short.   Hopefully, the info in the XLS provides sufficient detail.   If not, please don't hesitate to ask for additional info.

Thank you in advance!!
EEH

Macro / module searching for &quot;message prefix&quot;

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Macro / module searching for &quot;message prefix&quot;

Macro / module searching for "message prefix"