double clicking on cells to filter data

Hi Guys,

Please see attached. I've got some code on Sheet 2 of the workbook that when I double click on cells in column 3 it filters in sheet 1 between the 2 dates. How can I add further columns to double click cells, for example on the sheet 2 I want to double click on cells in column 4 to filter for the number of contracts? Is that possible?

Any help would be much appreciated.

Many thanks
Harry

Thanks - I don't need message boxes, I just need it to filter in sheet1 for column 4 to show number of completed contracts when I double click on cells in column 4, sheet 2.

At the moment when you click on the cells in column 3, sheet 2, the 1st column is filtered for dates in sheet 1.

I want to do the same as that but for contracts completed.

Hope it makes sense
Harry