Match dates from 1 sheet and then copy the interior colour from a different column to another sheet

[danbates]

Hi,

Please can someone help me?

On my Shifts sheet I have the dates from 01/01/2023 up to 31/12/2030 running down column A but each date is two cells merged because in column B is the colour of our day & night shifts.

So it reads: 01/01/2023 is in A1, 02/01/2023 is in A3 and so on with the two different interior colours to each date in column B.

On the same sheet I also have a formula that finds the 3rd Sunday of each month for the year 2023. This range is Q1:Q12.

What I would like is a VBA code that can look for each date on my Shifts sheet in the Q1:Q12 range, match them dates in column A and then copy the lower colour in column B to my Monthly sheet. The range is B7:B18.

As an example:
If Q1 was showing the date 01/01/2023 which is in cell A1 then I would need the interior colour copied from B2 to my Monthly sheet B7.

Any help would be appreciated.

Thanks

Dan