Hi,

I am looking at building a macro for the below condition.. please do the needful.

I have the folder keywords in column A, folder paths in column B and i want to know if the folder with the keyword is present in that folder path and if present it should throws message as PASS or FAIL in column C and also i wanted to know the last modified date of that folder in column D.

Thanks in advance for your help...