Dec 06 2022 05:39 PM
Hello All, I have a spreadsheet with list of file names in Column A. I have stored all the associated files (filename being the contents of Column A) in a folder on One Drive.
I intend to link the files with cells in Column A. The sheet has > 500 rows so doing it manually is going to be very cumbersome. I have tried two approaches in Column B & Column C based on my search in this sub. But both cases open the folder and not the specific file.
Column B - =HYPERLINK("https://",A2)
Column C - =HYPERLINK("https://" & A2 & ".docx" & A2)
Unfortunately both only open the linked folder but not the
2)
I also intend to know if the exact match is available in the folder location on not.
PS: I am not very familiar with VBA. So any help without or minimal use of VBA would be greatly appreciated. Thank you !