Hi Conkers.
This is looking like a User Defined Function. Open up a VB Editor window (Alt + F11) and the select Insert > Module. Copy the following code into the module window
Code:
Function GetCombined(cell As Range) As String
'Lists the Hyperlink Address for a Given Cell
'If cell does not contain a hyperlink, return default_value
Dim FullCell As String
Dim Row As Integer
Row = cell.Row
FullCell = Range("C" & CStr(Row)).Value
Do Until FullCell <> ""
Row = Row - 1
FullCell = Range("C" & CStr(Row)).Value
Loop
GetCombined = Range("B" & cell.Row).Value & Range("C" & CStr(Row)).Value
End Function
Now, in the D3, enter =GetCombined(D3) and copy it down as far as you need. That should do the trick. It's all hard-coded so if you insert/delete columns, it will all go to shit, but hey, it's hometime.
Social Networking Bookmarks