I have csv files with up to 100,000 lines. I want to change the value of column C from Visual to Pass (or leave it alone if it already says Pass) based on whether column D on each line contains one of about 20 different phrases (most of these are long phrases). The list of phrases which should invoke a change from Visual to Pass is in a separate worksheet -- or I can add it to another tab in the same worksheet (I have 20+ files to check on a monthly basis). Columns A and B should not be touched.
Currently I am manually checking and changing Visual to Pass, but there must be an easier/faster way. I've searched for similar problems, but can't find any. I'm just a beginner with macros and VBA, so would appreciate any suggestions.
Thanks!
Currently I am manually checking and changing Visual to Pass, but there must be an easier/faster way. I've searched for similar problems, but can't find any. I'm just a beginner with macros and VBA, so would appreciate any suggestions.
Thanks!