Search dates and keyword and return value if keyword is present and date falls within date range

[Gaz12345]

Hi all

I have a schedule that is very dynamic and want to create a macro to update my timeline, when the schedule changes

I can easily export updated schedule data into a table like below

I would like to look at the below purple keywords and the dates in row 5 and check both against each line in the table and populate the grid if keyword is found in "Task Name" column and date from row 5 is between start and finish date in the table, the grid would be populated with the task type in the corresponding line

Regards