Extract and count data - macro

Dear all,
I am writing to seek help, in creating a macro which can count specific data and display the count in another sheet, by matching up the same date from sheet1 and sheet2.

for example, I have data in sheet1 (q_type & d_type), and i would like the macro, to be able to find and extract all data from the date[16/06] types from sheet1 and count all the d-types [LO], which have q_type of [CV, TK, TR]. then display the count for each q_type's in sheet2, under the same date [16/06] in row 1 of sheet2.

I have attached a sample data in sheet1 and desired output in sheet2, for date [16/06], for further reference.
sample1.xlsm

desired sheet2 output:
LO TK 2
LO CV 1
LO TR 2


many thanks for your help and time.

Hi
I dont think you need a macro if I understand you correctly as you can use a Pivot Table to achieve what you are after. See attached sample, hope it helps.
Good luck
Tony