Attach Hyperlink From Column To Cells In Another Column VBA

I am looking to create a VBA code that can create hyperlinks for me.

If you look at the picture what I'm looking for is an code that will take the hyperlink from the second column to the right of the column containg "Excl." (here it is column I) and attach as an hyperlink to the corresponding row in the last filled column. The vba code should check the cells in the first row to verify if data is there (Cell D1, E1.....).

In the example attached the code should take the link in K2 and attach to E2, K3 to E3, skip K3 and K4, attach link from K5 to E5 and so on, until the last row (sometimes 100, sometimes 200).

If there weren't a date in E1, but only in D1, then the links should have been attached to as K2 to D2, K3 to D3 and so on.

It is important that a hyperlink is not attached if the cell is blank. (had problems with this as well).

For the hyperlink formula I have used =IF(G4"";HYPERLINK("C:UsersTommyDropboxXYZ"&G4&".jpg");"")