Copy to next hyperlink

[Orangeanorak]

Hi people
Don't know if this can be done.

Cell C1 has hyperlink to a document ABC1
Cell C2 has hyperlink to a document ABC2

Is it possible to copy a formula into each cell in range C3 to C100 to hyperlink to documents ABC3 to ABC100 without having to enter the hyperlinks individually.

Hope this makes sense

Thankd

 

[Arithos]

Hi people
Don't know if this can be done.

Cell C1 has hyperlink to a document ABC1
Cell C2 has hyperlink to a document ABC2

Is it possible to copy a formula into each cell in range C3 to C100 to hyperlink to documents ABC3 to ABC100 without having to enter the hyperlinks individually.

Hope this makes sense

Thankd

something like this maybe,

Sub hyperlinks()
'
filepath = "type filepath to the document(s) location"
  
   For i = 1 To 100
   Cells(i, 3).Select
       ActiveSheet.hyperlinks.Add Anchor:=Selection, Address:= _
        filepath & "\" & "ABC" & i, TextToDisplay:= _
       "ABC" & i
    Next i
End Sub

This is assuming you have the documents in the same folder, and that they are named ABC1-100