I currently have a Macro that will search through source data for any values that are built into an array I have constructed. It will also put an X in the column next to the data when it is found.
What I am looking to add to this process is a conditional or tiered search. Ideally, I am looking to be able to search for a value within a specified number of characters of another established value.
Ex - Find "Phone Number" within 50 characters of "Attraction Name"
The reason I need this is I have a very large pool for source data, and certain elements like "Phone Number" repeat throughout, but I would like to be able to search for specific instances.
Any insight or advice would be most welcome. Ideally I would like to integrate the conditional format search with my existing macro so I could continue to mark the column next to it when the value is found.
Thanks in advance for any and all help.
What I am looking to add to this process is a conditional or tiered search. Ideally, I am looking to be able to search for a value within a specified number of characters of another established value.
Ex - Find "Phone Number" within 50 characters of "Attraction Name"
The reason I need this is I have a very large pool for source data, and certain elements like "Phone Number" repeat throughout, but I would like to be able to search for specific instances.
Any insight or advice would be most welcome. Ideally I would like to integrate the conditional format search with my existing macro so I could continue to mark the column next to it when the value is found.
Thanks in advance for any and all help.