Excel Help

[Conkers]

In the attatched worksheet I wish to make a new column (column D) of the 1st 2 columns combined. Pretty simple.

My problem is that the 2nd column isn't always populated and in this case it should take the last populated data and use that...


Is this possible ??

[cassy34]

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

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.

[Conkers]

Thats the ticket... thanks very much!