I have an interesting use case wherein i have an excel file which has in it’s first column some file names.
What i need to do now is for each of these file names in my first column i need to check whether the file exist in my local folder.(The files resides in my system, i just need to check if the file name from my excel file is there in the local folder or not).
If the file exists i need to create a hyperlink in the excel sheet for the given filename.
Attaching the first column of my excel sheet(Second image) and my folder(First image)