HELP-- Filtering and copying data to a new sheet (w/ macro)
 

Ok... I have been trying for a week now and can't get this figured out. Can
anyone assist??

I have a worksheet with statistics on it. What i want to do is to filter for
2 criteria and then copy that data over to another sheet... so that i will
have ALL of the clerk data for that particular clerk. This is what i want to
happen (with a macro):

Begin on Monday
Filter for CLERK A
Filter for "NO" (part of a column that askes if a mistake was made)
Copy the FILTERED data only
Move to the CLERK A Tab
Select the next avilable cell
Paste it into the tab

Repeat for Tuesday through Sunday

Now, the filtering i don't have a problem with. I have two problems.
Selecting the error data (which changes with each of the 12 clerks) and then
the selecting of the next available cell. Any suggestions??