kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I am having issues with getting a task accomplished.
I have found some scripts on the net but they all seem to get me just half way through the journey. They could find just one string .
In a column say column C, I have data in the form 00-01-02-03-04 and I want to find two of the sub stings either from values in two cells or an InputBox (whichever is cool). Say "00" and "03" (Both must be located not just one). I am not sure how excel is treating those 00 and 03 etc so I am using "string" .
So when those matches are found, hide all rows except those matched.
Else display a message box "No Match Found"
I just hope this is achievable.
Thanks in advance
Kelly
I have found some scripts on the net but they all seem to get me just half way through the journey. They could find just one string .
In a column say column C, I have data in the form 00-01-02-03-04 and I want to find two of the sub stings either from values in two cells or an InputBox (whichever is cool). Say "00" and "03" (Both must be located not just one). I am not sure how excel is treating those 00 and 03 etc so I am using "string" .
So when those matches are found, hide all rows except those matched.
Else display a message box "No Match Found"
I just hope this is achievable.
Thanks in advance
Kelly