Find and Link VBA Code

[Mission_Control]

I have a basic spreadsheet to indicate bill payment status but what I would like is to automate my hyperlinks in this sheet. My first column is simply an invoice number followed by other information in the adjacent columns. I'm sure it's possible and may have already been done (but I couldn't find such a script).

What I am looking to do is have a VBA code automatically link a cell to a file or directory on my computer with the same corresponding name, without all the files having to be in one file as a mass conglomerate?
So, if cell A2 = "Invoice #23456" the cell would link to John Smith's home over in my residential work folder with the file name "Invoice #23456".
The path name would look roughly: /username/company/residential/JohnSmithAddress/Invoice #23456
But, if cell A3 = "Invoice #23457" the cell would link to Jane Doe's company over in my commercial work folder with the file name "Invoice #23457"
The path name would look roughly: /username/company/commercial/JaneDoeCompany/Invoice #23457

If there is already a script or add-on or something made that would be fantastic as I do not have the experience in VBA to execute this idea myself. Any ideas would be greatly appreciated.

 

[Andrew Poulsom]

Welcome to MrExcel.

You can use the HYPERLINK function if you can construct the link from your data.

 

[Mission_Control]

Welcome to MrExcel.

You can use the HYPERLINK function if you can construct the link from your data.

Right, I know how to add a basic hyperlink. I was looking for a way to automate the process so that I didn't have to manually hyperlink thousands of invoices.

 

[Andrew Poulsom]

It's a function:

HYPERLINK function - Excel - Office.com