Macro to extract values based on Month and year

[howard]

I have dates in Column b and values in Col C


I need to extract the items in Col A to C in sheet 'Data" based in the month and year in Col P and total value in Col Q and copy these to sheet Extraction


I have manually extracted the data to show you what I am trying to achieve

I want to extract the individual items where the value equals the value in Col Q as well as for the month and year in Col P


I would like a macro to extract this automatically

I have posted on the link below as well

Macro to extract values based on Month and year [SOLVED]

I have dates in Column b and values in Col C I need to extract the items in Col A to C in sheet 'Data" based in the month and year in Col P and total value in Col Q and copy these to sheet Extraction I have manually extracted the data I would like a macro to extract this automatically

www.excelforum.com

It would be appreciated if someone could kindly assist me



macro to extract values based on month and year macro to extract values.xlsx

 

[howard]

I just used sample data so strong possibility that I duplicated values.