Hello,
I apologize as I am trying to minimize turning to the forum for basic problems. In trying to properly adjust the code, I have run into an issue regarding the .Pattern line of VBA code.
Here is the excellent code that was given to me:
When I apply the code to the data (see attachment), this is the result and what I need:
Desired Results.jpg
However, I tried to adjust the .Pattern formula to parse the other data from the same document. I attempted this by replacing:
with
The result I get is:
Store Promotions Parse Attempt.jpg
I also tried replacing:
with
The result I get is:
Online Day Stages Parse Attempt.jpg
I'm very new to VBA code and I think that my mistake is in understanding how Regular Expressions work. Would it be possible for someone to correct my two attempts (as seen above) at changing the .Pattern formula? Also, if it is convenient, could it be briefly explained why my adjustments do not work with the current Regular Expression?
Thank you so much for your time and I look forward to any assistance offered.
Bookmarks