combine text based on a criteria

[LJ1996]

Hello,

I am struggling with finding a way to solve this problem. I would really appreciate your support.

I've got a spreadsheet with tasks and the dates they start and end and who does them (resource)... I want to create another spreadsheet that shows me who does what on which day.. this pic is an example.


https://ibb.co/nn6gRc



Thanks!

 

[PCL]

Assuming data from A1 to D3 versus your picture
Assuming result dash bord from M1 to P3
N2 = Ressources(N1;M2;$A$1:$D$4)
With next UdF

Function Ressources(ByVal WkDay, ByVal Ress, Data As Range) As String
Dim I  As Integer, LR  As Long
    With Data
        LR = .Cells(.Rows.Count, 4).End(3).Row
        For I = 1 To LR
            If ((.Cells(I, 2) <= WkDay) And (WkDay <= .Cells(I, 3)) And (.Cells(I, 4) Like "*" & Ress & "*")) Then _
                Ressources = Ressources & "," & .Cells(I, 1)
        Next
    End With
    If (Len(Ressources) <> 0) Then Ressources = Mid(Ressources, 2)
End Function