Hi Everyone,
Ok so I have a sheet called "Cal" that is made up of Event Names Down Column H and Dates from 1st April 2018 to 1st April 2021 along Row 10 (Range J10:APM10)
I have another sheet called "Data"
Down Column D is the Event Name, Column E is start date, Column F is end date.
so what...