[firzhugh]

Hi, I have got an Excel spreadsheet which has incident numbers in column A. For each of these incidents I need to put in hyperlinks which are very very similar. The first part of the hyperlink is the address to the database and the second part is the Incident number itself. I'm trying to create a macro which automates the process of putting in the hyperlink plus the incident number in. Can this be done?

[computerman29642]

Welcome to the forum.

I am sure what you want can be done. Would it be possible for you to attach a copy of the workbook (remove senisitive data with dummt data)?

[Rollin_Again]

Are the hyperlinks going to be replacing the data in column A or will you be putting them into an adjacent column? Can you provide us with a sample hyperlink address??

Regards,
Rollin

[firzhugh]

Hi, thanks for your replies. I don't want to replace the text or put it in another column, I just want the macro to add a hyperlink to the incident number with a link which looks similar to: http://www.database.com/file?123456. The only thing that changes in these links is the incident number which are in column A. I attach a sample spreadsheet.

Thanks for your help

[Rollin_Again]

Try the code below. Just change the number in red to reflect your true starting row number.

Sub AddHyperlinks()
    
For i = 2 To Cells(Rows.Count, "A").End(xlUp).Row

ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & i), Address:= _
        "http://www.sampledatabase.com/file?" & Range("A" & i).Value

Next i
    
End Sub

Regards,
Rollin

[firzhugh]

Thanks very much!!!