Auto Create Hyperlinks to files on **

[kevin1010]

We have an excel document with many entries that correspond to individual files. The files are located in multiple sub-folders.

Here is an example: {} indicate a column

{A3} A1.1.1 PROCESS
{A4} A1.1.1.1 PROCESS DESCRIPTION
{A5} AD159-S00000-D-RPT-01231 {C5} PROCESS DESCRIPTION
{A6} A1.1.1.2 DESIGN BASIS CRITERIA
{A7} AD159-S00000-D-RPT-01227 {C7} BASIC ENGINEERING DESIGN DATA

The bolded words are the actual folder structure.
The non-bold is the actual file name minus the extension.
The italic words are a description of that file.
This permeates through the entire excel document. Some folders have over a 100 file names while others may only contain a few.

There are over 6000 lines in the document. Is there ANY way to automate this process instead of clicking each individual line and hyper-linking them one by one.