Im not experienced with Excel and I'm looking for a code for an Excel workbook at my job.
We need to have a set column to add hyperlinks by just typing in the file names.
These Hyperlinks are "shortcuts" to find the file in our server. Instead of having to enter the whole path C:\FILES\FILENAME we could just type the FILENAME and it hyperlinks to that path.
We have Column "E" set to enter in all FILE NAMES saved in "C:\FILES\FILENAME" - By simply typing in the FILENAME it finds it and opens the file.Capture.JPG

I Hope this makes sense and any help would be appreciated, thanks. Hope the picture attached helps