VBA to create Hyperlink

[rwitte]

Hi All,

I have a spread sheet (excel 2016) that has 2000 rows of data (not consecutive).

Column Z has the following formula to create the text for a hyperlink: =IF(U2="Vetted","\\SERVERS.XXXXXXX.COM\SHARE\SHARE\RRR\GRAPHICS\QQQ"&G2&".pdf","")

Column U is used to state the information in the rest of the columns (rows) are complete
Column G is the name of a procedure (file saved in another location)

I am trying to come up with VBA to run through this that will:

Make sure rows are complete (U = "vetted")
Check if hyperlink is established in column G
If not, copy value from column Z (hyperlink text) into hyperlink for cells in G

Thanks