Macro / module searching for "message prefix"
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--Searching-for-Message-Prefix.xlsx
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--Searching-for-Message-Prefix.xlsx
ASKER
Martin:
Thank you for the lightning-fast response... I appreciate it.
Ultimately, whatever is easier for extraction purposes. If either method is equally straight-forward, then I would prefer to add the content to another tab (within same spreadsheet).
EEH
Thank you for the lightning-fast response... I appreciate it.
Ultimately, whatever is easier for extraction purposes. If either method is equally straight-forward, then I would prefer to add the content to another tab (within same spreadsheet).
EEH
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Rgonzo1971, Martin Liss:
Both solutions work great... thus, I wanted to award points to both of you. I hope that's ok.
Given that Rgonzo provided his solution first, I awarded the majority of points to him.
Again, both solutions exactly follow the envisioned process. Thank you for coming up with such an excellent solution!!!
As always, I appreciate your assistance.
Cheers,
EEH
Both solutions work great... thus, I wanted to award points to both of you. I hope that's ok.
Given that Rgonzo provided his solution first, I awarded the majority of points to him.
Again, both solutions exactly follow the envisioned process. Thank you for coming up with such an excellent solution!!!
As always, I appreciate your assistance.
Cheers,
EEH
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
ASKER
Rgonzo1971, Martin Liss:
Again, thank you for your most excellent help yesterday. Based on the same process, I now have a need for another process. I think this one, however, may be a bit more challenging (at least from my perspective).
Below is the URL (new question):
https://www.experts-exchange.com/questions/28911018/Macro-module-searching-for-message-content.html
It would be awesome if you please have a look at this requirements/need.
Thank you in advance,
EEH
Again, thank you for your most excellent help yesterday. Based on the same process, I now have a need for another process. I think this one, however, may be a bit more challenging (at least from my perspective).
Below is the URL (new question):
https://www.experts-exchange.com/questions/28911018/Macro-module-searching-for-message-content.html
It would be awesome if you please have a look at this requirements/need.
Thank you in advance,
EEH
"...the "scan" (in column B) should extract content of both column A and column B into another worksheet (or external XLS file)."
Do you sometimes want one or the other or can it be only a worksheet in the current workbook?