How to hyperlink current sheet to last cell with data in it in a specific row on another sheet

[Samlise]

Hi

Hope you can help.

I currently have a macro that saves and renames a sheet using a unique name from cell data, but I would also like it to automatically add a hyperlink to this current sheet to the last cell that has data in it in column 'E' on a sheet called "Log".

' Creates a new sheet based on the last number sequentially created after transfer
   
    Sheets("Transfer").Copy After:=Sheets(Sheets.Count)
    ActiveSheet.Name = Sheets("Data Validation Lists").Range("AC2").Value
    
    With ActiveSheet
        .Name = Sheets("Data Validation Lists").Range("AC2").Value
        pdfName = .Name
        pdfFullPath = pdfPath & "\" & pdfName
' Create PDF
        .ExportAsFixedFormat Type:=xlTypePDF, FileName:=pdfFullPath
    End With

Cheers

 

[Yongle]

thanks for your feedback