Hyperlink with VBA using column as reference.

[eli_m]

Hi,

My data looks something like this:

	A	B	C
1	Name:	Date Of Birth:	Reference:
2	SMITH, John	12/03/1988	K3472
3	JONES, Kayla	27/04/1962	K7895
4	RUSS, Tim	08/07/2022

I want the names (A2 & A3) to be hyperlinks using the data from Column C. The link to the website:
www.test.com/reference/COLUMN-C-VALUE-HERE

So, for A2 I want SMITH, John hyperlink to www.test.com/reference/K3472
and for A3 I want JONES, Kayla hyperlink to www.test.com/reference/7895

I want RUSS, Tim not to be hyperlinked because C4 is blank.

Is this possible?

I am guessing it would have to be VBA as if it's a formula in A2, A3, A4, etc it would be deleted when I type that persons name in.

Any help would be great.

In my actual spreadsheet, The persons name is in column A and the Reference column is column Q.
The data is in A2:AS200

Thanks in advance!

 

[eli_m]

anyone know if this is possible?

 

[eli_m]

bump