Group and Colour Rows by Area and Date

Hi All,

this is an ongoing project I have been working on but I have recently made changes to the sheet and now my VBA does not work. I am no expert in VBA's so was hoping for some help.

I have attached my spreadsheet so you can take a look, but I am currently working on the 'Completed' worksheet. I am hoping to sort entire rows based on the drop selected in column C 'Area'. I have filled the colours that I would like the rows to be coloured, but I would like this to be automatic when one of the 4 drop downs is selected. I would then like the rows to be shown in date order (newest to oldest UK format) based on column I 'Implemented' for each area.

Can anybody help with this please?

Dan