Hi everyone. I am super new in doing macros/VBA codes. I just want to ask about this project that I want to develop.
We currently have a macro that automatically generates the names of files in a specific folder. However I wanted to add something like a "cross-checking" power in which those filenames should contain specific texts/words that are available on a list in a separate spreadsheet. And if they do not contain such texts/words, they would be marked red or highlighted.
Hope I was able to explain the situation clearly! Really really need your help on this. Thanks!
We currently have a macro that automatically generates the names of files in a specific folder. However I wanted to add something like a "cross-checking" power in which those filenames should contain specific texts/words that are available on a list in a separate spreadsheet. And if they do not contain such texts/words, they would be marked red or highlighted.
Hope I was able to explain the situation clearly! Really really need your help on this. Thanks!