Macro to select data by certain criteria

[RockyM6767]

I can do this manually with the use of sort and filters, but I'm new to macros and would like to run this procedure automatically.
I need to write a macro to copy all rows of data when the specified criteria in a specific column is found.
Here is a snap shot of the data. I want to copy the selected rows to another sheet.



Column Headings

Team Name Type Tot F. Tot Pts. Largest
Red John Male 10 100 9
White Mary Female 12 120 10
Blue Johnny Male Youth 15 150 12
Orange Jill Female Youth 20 200 15

So I want to sort the data by Largest---> No problem there
Then I want to copy data based on type(s) into a new sheet.

I need to copy male youth and female youth types--> to a new sheet called awards
Sometimes that type will not be found. Example no males entered the contest, etc.

Appreciate the help
Rocky

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic