Move data to another sheet based on certain parameters

I have two data items. Date and number. I wish to have the date and number over a certain amount copied to another sheet. I also desire a count of how many entries it is. In other words I am tracking violations for the year. So I want the date the violation occurred, the amount of the violation and how many violations occurred that year on another sheet. Any ideas would be appreciated. I hope I am posting to the correct thread. If you don't know I don't need to know that.
Thanks,
Paul

You need to use "advanced filter" to move your data over a certain amount to another sheet. You can search youtube "advanced filter" to get instructions on how to do it. I have 2010 so I'm not sure the exact steps you need to do but advanced filter can easily accomplish what you are asking.

I'll try to explain it here the best I can. On your main sheet you have headers like "Date" and "Violations". Create a new sheet and in A1, type "Violations" and in A2 type ">6". This means you want to copy over lines that have a number greater than 6 in the Violations column. Go back to your main page and click inside your date anywhere. Go up to the DATA tab and under the Sort&Filter area click "Advanced". Click on "Copy to another location" and in the "List Range", make sure all the data on your main page is selected. In the "Criteria Range", go over to your new page and highlight both A1 and A2. Under "Copy to" select cell A4 on the new page and click "ok".

Thanks for the information. I did watch the video you mention, but when I attempt it I receive an error message that states: "database or table range is not valid". I will try to attach the file. The idea was to have any of the fields on the first sheet that are over a certain parameter to show up on sheet 2 under the heading violations. I'm sure it is me missing something.
Thanks for your help.
Paul

OK, on "Sheet2", you need to have "Fecal Bac" in A1 and ">=20" in A2(You should actually change it to ">19" if you want 20 and higher)

Select "Sheet1" and click somewhere inside your date, say D11. Now, go up to the DATA tab and select "Advanced" in the Sort & Filter area. Click the "Copy to another location", in "List Range", put !$A$7:$BE$373 (this is all data range on sheet1) In "Criteria range" put Sheet2!$A$1:$A$2 (this is the criteria from sheet2) In "Copy to" put Sheet2!$A$4 (this is where you want the copied lines to appear) then click ok.