Extract data with 2 criteria

[Charles]

Hi,

I modified the code supplied by "Admin"
In this example I used a command button to populate the data to the "Result" sheet.
All you need to do is select the data in C1 and click Run.